We are using Redis search utility to cache our data in JSON format. We have stored approx 4.3 milions records. Where id is the key and property such as color, latitude, longitude, and googlepolyline geometry (string) as an attribute.
We have created index also on latitude and longitude columns that are numeric using Ft.create command.
We are searching data based on min-max latitude and longitude range.
It works perfectly and return result very fast, but suddenly after 2-3 hour when we update color property, either index got deleted automatically or redis search return null result when data is present for the given search criterion.
If we dont update anything then it works fine, but after property updation it starts behaving wierdly.
It either return less records than expected or return null.
When we refill the whole data and create index again then its starts behaving normally.