EOF Caching / performance question
EOF Caching / performance question
- Subject: EOF Caching / performance question
- From: Guido Neitzer <email@hidden>
- Date: Wed, 8 Mar 2006 12:10:13 +0100
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?
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)?
cug
--
PharmaLine, Essen, GERMANY
Software and Database Development
Attachment:
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________
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