I'm wondering how much improvement this caching is over the database caching
the parsed SQL statement and results (disk blocks)?
In Oracle, if you issue a query that is cached, it doesn't need to be parsed.
If the resulting blocks are also cached, there isn't any disk access. If the
database is tuned, you should be able to get stuff out of cache over 90% of
the time. I don't know what other databases other than Oracle do.
What are the advantages of implementing your own cache? Is there any reason
other than speed?
--
Brian Cocks
Senior Software Architect
Multi-Ad Services, Inc.
[EMAIL PROTECTED]
