I am interested in better understanding how far the indexes may get behind when using unbounded queries vs Request plus queries at scale.
If I can expect most indexes to be less than 1s behind most of the time, then I think that would be very acceptable.
However, it’s hard to find information about what to expect at scale. Some of the most helpful information I’ve found is in this post: http://blog.couchbase.com/2016/may/high-performance-consistency
The post seems to indicate that GSI indexes are updated every 200ms (on ForestDB). But how long can a single update operation take? e.g. Let’s say I suddenly dumped 100,000 documents into one of my buckets. Up to 200ms later, the index update would begin. How long might this take at scale? Are we talking <1s or maybe like 10s?
I know this varies greatly depending on the server and many other factors, but I’m just looking for more detail into how these index updates work and how they perform.