Re: EOF Caching / performance question
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