Yeah you'd have to change this to a where fk_id in (select id from origtable limit 100). Possible but might be tricky to plumb that through.
Sent from my iPhone On Jun 27, 2012, at 8:56 AM, Chuck Hill <[email protected]> wrote: > I recall seeing the same thing. I'd have to look at the SQL again to see if > it is possible to migrate the limit a sub-query in the pre-fetches. My first > guess is that it would not be trivial. > > Chuck > > > On 2012-06-27, at 7:10 AM, Kieran Kelleher wrote: > >> I don't have the answer to that off the top of my head. Interesting question >> though. >> >> On Jun 27, 2012, at 9:23 AM, Henrique Gomes wrote: >> >>> >>> Also, >>> >>> I had trouble some time ago, because a fetch *was* using LIMIT (on >>> Postgres) but the subsequent fetch of prefetchingRelationshipKeyPaths were >>> NOT. >>> Is that expected behavior? I assume so, the result of LIMITing the fetch >>> might not bring the relation tuples corresponding to the initial LIMITed >>> fetch. Right? >>> >>> HG >>> >>> On Jun 27, 2012, at 12:55 PM, Kieran Kelleher wrote: >>> >>>> Also, you can verify by checking the SQL that is being sent to the >>>> database rather than just guessing that LIMIT is not being applied. It >>>> might be a big relationship that is causing OOM exception. Or maybe you >>>> have not allocated enough memory to your app. >>>> >>>> On Jun 27, 2012, at 7:52 AM, Kieran Kelleher wrote: >>>> >>>>> 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/lists%40farol.pt >>>> >>>> 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/chill%40global-village.net >> >> This email sent to [email protected] > > -- > Chuck Hill Senior Consultant / VP Development > > Practical WebObjects - for developers who want to increase their overall > knowledge of WebObjects or who are trying to solve specific problems. > http://www.global-village.net/gvc/practical_webobjects > > > > > > > > > > _______________________________________________ > 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/mschrag%40pobox.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]
