db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From mogoye <sylvain.rou...@eloquant.com>
Subject Re: Performance problem with derby
Date Fri, 02 Sep 2011 09:48:28 GMT

Should I understand that is no way for me to optimize a request used to
display few elements on a large result using pagination with derby 1.0.8 ?

Dag H. Wanvik-2 wrote:
> On 8/31/2011 7:19 PM, Mike Matrigali wrote:
>> The OFFSET feature is relatively new to derby and I am not sure if the 
>> optimizer has been fully updated to understand it.  Maybe someone who
>> knows more about the OFFSET feature can comment if the optimizer has 
>> been updated to know that this query is only going to look at 50 rows
>> rather than all of them?
> It hasn't been updated to understand this yet.
> Dag

View this message in context: http://old.nabble.com/Performance-problem-with-derby-tp32364853p32385509.html
Sent from the Apache Derby Developers mailing list archive at Nabble.com.

View raw message