cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Robert Zeigler <robert.zeig...@roxanemy.com>
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.

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


Mime
View raw message