Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- Caching mysql queries
August 28, 2006, 12:26 am
rate this thread
I'm a little confused about the working of the mysql-cache. I don't
understand the mechanism. What is it exactly you cash ? The result of a
query ? And what if there are certain records addes or removed ?
Please explain this because I need this knowledge to support a customer
of mine who wants to know this technique in detail.
Re: Caching mysql queries
Right, the results of a query are cached, if possible. They are
associated with the exact query that generated the results.
If any records are added or removed or updated in the underlying table,
the cached result set is invalidated and discarded. The next execution
of that query must be run against the current state of the table. The
results will be cached again, and that cached copy can be reused while
the table is unchanged.
Why don't you read the chapter in the documentation and then come back
if you have more specific questions. Your questions are probably
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum