I know array indexing is available on Couchbase Server; is there a plan to implement this for Couchbase Lite? We have a database with 100K-1M documents. With Couchbase Lite 1.4 views we can effectively index arrays on those documents and query them. Performance is inadequate with Couchbase Lite 2.5.
We’re exploring alternatives, such as creating our own ‘lookup table’ of docs mapping the keys to the parent docs on the device, which helps, but is still less performant than on 1.4. We are also exploring creating those lookup docs in sync gateway, but that can increase the number of docs to replicate by 3x-10x, which will likely have a significant adverse impact on replication performance.
If support for array indexing on Couchbase Lite is coming in the near future that would be very helpful to know.