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.


Mime
View raw message