|
|
|
| Problems? Is your data what you think it is? | |
| PerlMonks |
Re: Re: Re: System V shared Memory Perl Module (more of a C question than Perl) aka Efficient SQL result cachingby hakkr (Chaplain) |
| on Apr 03, 2003 at 08:25 UTC ( [id://247703]=note: print w/replies, xml ) | Need Help?? |
|
I have the same sort of problem with an overloaded db doing queries where the results only change 5-10 times a day.
I was thinking of only triggering my select queries when the cgi that updates the data is used. So my script would run off a static file and the file would only get updated when the data changed. You think I can use these memory module instead to get rid of the static file and store my results in memory. I'm in Mysql Apache as well and I am pretty sure that mysql has a query cache.
In Section
Seekers of Perl Wisdom
|
|
||||||||||||||||||||||