in reply to Re: Perl/CGI + MySQL: How many calls is too many?
in thread Perl/CGI + MySQL: How many calls is too many?

Cache your entries in perl, and use them elsewhere. You might be able to shave some cycles off by throwing your results into a hashref and keeping them around a little longer.

Excellent point. You might also want to consider the Cache::* modules for your caching needs. They offer fixed size cacheing, which can help you keep from running out of RAM/disk. The file based caches are very fast, and might be ideal for that less often needed data.

Also take a look at Perrin Harkin's excellent EToys article on perl.com for a great story on effective and intelligent cacheing.

  • Comment on Re: Re: Perl/CGI + MySQL: How many calls is too many?

In Section Seekers of Perl Wisdom