• 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: EOF Caching / performance question
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: EOF Caching / performance question


  • Subject: Re: EOF Caching / performance question
  • From: Chuck Hill <email@hidden>
  • Date: Wed, 8 Mar 2006 08:14:32 -0800


On Mar 8, 2006, at 3:10 AM, Guido Neitzer wrote:

Hi.

As I understand, the EOF caching mechanism fetches not every time a request is made fresh data from the database. Okay. When I use standard qualifiers and fetch specifications but tell the fetch specification to fetch raw rows, will they get cached?

No, they don't get cached. And the data is fetched again if you try and turn them into EOs.

If performance matters, would you recommend using optimized sql and use the database caching mechanism (about 5 to 8ms for each individual fetch; about 8 to 10 fetches needed to build a typical page - direct action based so nothing can be stored between requests) or setting the EOF cache times to a few minutes and fetch EOFs (raw rows if they are cached)?

Assuming your page just fetches what it needs to display and does not display a large amount of data, why use raw rows at all? Why not just stick with EOs and take advantage of EOF's caching? If the page is actually running fetch specs, as opposed to just following relationships, consider caching the globalIDs somewhere so change that DB access into fault firing. I'm not sure if this is feasible in your case or not, but is worth considering.

Chuck

--
Coming in 2006 - an introduction to web applications using WebObjects and Xcode http://www.global-village.net/wointro


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/products/practical_webobjects




_______________________________________________ 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: EOF Caching / performance question
      • From: Guido Neitzer <email@hidden>
References: 
 >EOF Caching / performance question (From: Guido Neitzer <email@hidden>)

  • Prev by Date: Re: CustomQueryExpressionHintKey and rawRowKeyPaths? - SOLVED
  • Next by Date: <Kein Betreff>
  • Previous by thread: EOF Caching / performance question
  • Next by thread: Re: EOF Caching / performance question
  • Index(es):
    • Date
    • Thread