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
