I assumed that ( How can I force LIMIT to SQL statement in MySQL? 2012/6/26 Kieran Kelleher <[email protected]>: > It depends on the database plugin you are using. Some plugins take the > fetchSpec fetchLimit and incorporate it into the SQL statement in the > plugin's EOSQLExpression subclass. The default behaviour of EOF is to limit > in memory after the fetch. > > On Jun 26, 2012, at 10:23 AM, Gennady Kushnir wrote: > >> 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 protected]) >> Help/Unsubscribe/Update your Subscription: >> https://lists.apple.com/mailman/options/webobjects-dev/kelleherk%40gmail.com >> >> This email sent to [email protected] >
-- С уважением, Геннадий Кушнир _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
