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(type),transactionType,createdOn,sourcePhoneNumber,destinationPhoneNumber,debitType,rateType,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.
As far as ORDER BY param DESC is concerned:
In 4.0.0, we’d fetch all the qualifying documents from KV, then SORT it.
In 4.1, if the Index has the param and query is covered, the query will get data just from the index, but sill have to sort it. This will improve the performance as well.
We don’t have a mechanism to do create an index with DESC order yet. Our team is aware of this requirement.
Do you have any performance suggestions for the 4.0?
Is there any other way of working this out since this is quite of an “regular” thing to do
The problem is we cannot use views because the data must be filtered and sorted based on multiple dynamic parameters
Any ideas how to overcome the performance issues?