in reply to Re: Re: System V shared Memory Perl Module (more of a C question than Perl) aka Efficient SQL result caching
in thread System V shared Memory Perl Module (more of a C question than Perl) aka Efficient SQL result caching

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.

  • Comment on Re: Re: Re: System V shared Memory Perl Module (more of a C question than Perl) aka Efficient SQL result caching

In Section Seekers of Perl Wisdom