• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: fetchLimit don't affect SQL fetching limit?
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: fetchLimit don't affect SQL fetching limit?


  • Subject: Re: fetchLimit don't affect SQL fetching limit?
  • From: Kieran Kelleher <email@hidden>
  • Date: Tue, 26 Jun 2012 10:41:04 -0400

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@hidden)
> Help/Unsubscribe/Update your Subscription:
>
> This email sent to email@hidden


 _______________________________________________
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

  • Follow-Ups:
    • Re: fetchLimit don't affect SQL fetching limit?
      • From: Gennady Kushnir <email@hidden>
References: 
 >fetchLimit don't affect SQL fetching limit? (From: Gennady Kushnir <email@hidden>)

  • Prev by Date: fetchLimit don't affect SQL fetching limit?
  • Next by Date: Re: rawRows for UPDATE
  • Previous by thread: fetchLimit don't affect SQL fetching limit?
  • Next by thread: Re: fetchLimit don't affect SQL fetching limit?
  • Index(es):
    • Date
    • Thread