Beefy Boxes and Bandwidth Generously Provided by pair Networks
laziness, impatience, and hubris
 
PerlMonks  

Re: DBI : local persistent storage

by Thilosophy (Curate)
on May 25, 2005 at 08:02 UTC ( [id://460262]=note: print w/replies, xml ) Need Help??


in reply to DBI : local persistent storage

If you are using mod_perl or FastCGI you can store the data in memory, using a persistent variable (such as a package global). That is very easy to do, but does not work with vanilla CGI. If the data needs to be periodically refreshed, it cannot be shared among the mod_perl processes, but if that data is small, at least the memory penalty of having to store many copies (one in each process) is not an issue.

You can store (almost) any kind of Perl data to disk (or shared memory) with the core module Storable.

If you do not want to roll the code yourself, check the various Cache modules on CPAN.

As for the timestamp, I would include that in the cached data. You can then compare it after retrieving from the cache.

Replies are listed 'Best First'.
Re^2: DBI : local persistent storage
by merzy (Scribe) on May 25, 2005 at 09:13 UTC
    Thilosophy has some good suggestions, and I'll second the one for Cache::FileCache as a quick and easy way to get things cached locally.
      The only trouble is, it's dirt slow. It's slower than a simple query on MySQL. You'd be better off using Cache::FastMmap.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://460262]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others musing on the Monastery: (1)
As of 2024-04-19 18:30 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found