cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ilya Lazarev <>
Subject Re: Selecting with an offset / paging
Date Fri, 04 Dec 2009 16:42:24 GMT
using 1.2, forgot to mention

On Fri, Dec 4, 2009 at 5:41 PM, Ilya Lazarev <> wrote:

> Hello,
> I have a webapp that accesses an Oralce DB to retrieve records and do
> paging over the entire resultset (an expression is used that spans multiple
> tables). Recently when the number of results in total adds up to over 30000,
> the performance of the select query has dropped to unusable levels (30+
> seconds per query). The webapp never returns all 30000 rows so it's OK for
> the time being, but it certainly needs to be addressed.I wanted to do a
> select with a *"where rownum > a and rownum < b" *type query, but so far
> have not seen a way to do that. Does anyone have any tips how to do this? My
> other option is to rewrite the retrieval using SQLTemplate and calculate the
> dynamic sql based on parameters by hand, correct? Will the resultset contain
> objects with their relationships that way (ie.
> ((TableA)result.get(0)).getToTableB() ?) or flat data rows?
> Thanks!

  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message