Re: Cayenne Fetch Limit behaviour ?

From: Robert Zeigler (robert.zeigle..oxanemy.com)
Date: Tue Jun 16 2009 - 21:37:20 EDT

  • Next message: Malcolm Edgar: "Re: Cayenne Fetch Limit behaviour ?"

    I don't think the behavior changed, per se. Rather, setFetchLimit is a
    relatively new feature, and may not be properly supported by all of
    the db adaptors yet.

    Robert

    On Jun 16, 2009, at 6/167:28 PM , Malcolm Edgar wrote:

    > Hi Guys,
    >
    > On SQL Server we are finding that the setting the Fetch Limit on a
    > SelectQuery does not modify the SQL query, to set TOP or SET ROWCOUNT,
    > so the database is not limiting the number of rows returned, and it
    > appears that Cayenne is limiting the number of rows returned in
    > memory?
    >
    > This is killing our application with OOM errors. Did this behaviour
    > change? We are using Cayenne 3.0M5
    >
    > regards Malcolm Edgar

    This archive was generated by hypermail 2.0.0 : Tue Jun 16 2009 - 21:38:12 EDT