cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Robert Zeigler <>
Subject Re: Cayenne Fetch Limit behaviour ?
Date Wed, 17 Jun 2009 01:37:20 GMT
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.


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

View raw message