Re: SQLTemplate fetchLimit

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Sat Feb 17 2007 - 17:56:04 EST

  • Next message: Andrus Adamchik: "Re: Creating a GROUP BY query"

    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