fetchLimit don't affect SQL fetching limit?
fetchLimit don't affect SQL fetching limit?
- Subject: fetchLimit don't affect SQL fetching limit?
- From: Gennady Kushnir <email@hidden>
- Date: Tue, 26 Jun 2012 18:23:06 +0400
Hello all!
I am fetching from a table that has lots of records. So I decided to
fs.setFetchLimit(10) on my EOFetchSpecification, but nevertheless when
I perform ec.objectsWithFetchSpecification(fs) I get
JavaOutOfMemoryError.
It seems to me that fetchLimit does not actually convert to a LIMIT
clause in a SELECT statement in underlaying SQL. So the actual
limitation is made in memory after fetch.
Is it a conventional behavior or it is me doing something wrong?
Gennady
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden