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.
