#417 Allow query_cache opting-out

Slash 2.5/3.0
open
MySQL (16)
5
2004-10-23
2004-10-23
No

Many of our queries should never be stored in the MySQL
query cache. We can help MySQL save some of that cache
space, and time too, by telling it so.

Not sure of the best way of doing this, but the thing
that comes to mind is an instance var in $slashdb that
we could set that means "add NO_SQL_CACHE to all SELECTs".

Another way would be to declare a list of table names
that it never makes sense to use the query cache on
(obvious candidate: accesslog, and every other table
that typically changes every few seconds). Then all the
sqlSelect* methods would regex their $tables input
against that list.

Maybe both...

Discussion


Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.





No, thanks