Hi Gerald,
I got same issue with ordering:
select * from default where postingData > 20160801 order by postingDate
=> very slow 27s
but
select * from default where postingData > 20160801 limit 10 => very
fast 100ms
I'm using couchbase 4.5.0-2601. Can you advise this ? thank you
Regards,
On Wednesday, December 30, 2015 at 11:12:01 PM UTC+8, Gerald wrote:
>
> Hi Dipen,
>
> AS I posted on the Couchbase forum, the next release includes this fix for
> the performance of ORDR BY with LIMIT:
> http://review.couchbase.org/#/c/57495/
>
> Gerald
>
> On Monday, December 28, 2015 at 10:16:48 AM UTC-8, Dipen Patel wrote:
>>
>> Hello
>>
>> N1QL Performance on Order By
>>
>> We are testing N1QL and found a Performance issue when using a order by
>> in the query.
>>
>> I have index on type and lastName.
>>
>> Test Case:
>> * ordering by an attribute (lastName)
>> * paging using skip and limiting to 50
>>
>> The N1QL query returns the same results over 1.6 - 2.5 seconds
>> Select r.id, r.fullName FROM my_bucket r
>> WHERE r.type='user'
>> Order By r.lastName limit 50
>>
>> Using a view returns back ~700 ms.
>>
>> If I remove the order by in the N1QL statement, the results come back
>> under 100ms
>>
>> Thanks.
>>
>>
>>
>>
>>
--
You received this message because you are subscribed to the Google Groups
"Couchbase" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
