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
