On Feb 16, 2007, at 2:36 PM, Bryan Lewis wrote:
> Just checking my understanding of something... Does it make any sense
> to call setFetchLimit() on a SQLTemplate? We're supplying the raw SQL
> so I would think we'd have to hand-craft the fetch limit as well, say
> with a 'rownum' or 'limit'.
Really up to you. In this case Cayenne fetch limit will still work
(i.e. Cayenne will ensure that no more than X rows are read via
JDBC), but it is definitely more efficient to incorporate this syntax
in the SQL query to let the DB know and optimize the query accordingly.
Andrus
This archive was generated by hypermail 2.0.0 : Sat Feb 17 2007 - 17:56:40 EST