We are using couchbase 4.0.0 v.
We have database with over 11 million document.
My index looks like this “CREATE INDEX transactionSearch ON zipt(lower(
absoluteAmount) WHERE (lower(
type) = “transaction”) USING GSI”.
When using “order by param DESC” in cbq it is very slow (>5sec). Is there any problems with ordering and performance I should be aware. If there is any solution for speeding things up please help.