LIMIT is supported by the Wonder MySQL PlugIn since Nov 22, 2011, commit 6c511bb. You would need the MySQLPlugIn in your build path.
On Jun 27, 2012, at 3:13 AM, Gennady Kushnir wrote: > 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]
