I am currently using Enterprise Edition 7.1.3 build 3479 and an adaptive index to run ad-hoc queries over documents that contain many fields (20 to be precise). However, the sorting(ORDER BY) performance is quite slow (sometimes even timesout of predicate returns large data ~40million). I was wondering if there are any best practices or tips to speed up the sorting process when using adaptive indexes in Couchbase over documents with many fields.
I have tried reducing the number of fields I am indexing, but it still seems slow. Is there a way to increase the amount of memory available to the indexer? Are there any other indexing options in Couchbase that are better suited for sorting over documents with many fields?
I would greatly appreciate any suggestions or tips on how to improve the sorting performance with adaptive indexes in Couchbase over documents with many fields.