in reply to DBI : local persistent storage

Keep in mind that this may be an negative-effect cache, unless the rules for invalidation are merely time-based. The moment you start analyzing the data to see if it's time to blow the cache, you can be in the territory where it's easier to just ask the (tuned) database to give you the query results again. Databases are designed to process queries fast; it's good to let them do what they are good at.

-- Randal L. Schwartz, Perl hacker
Be sure to read my standard disclaimer if this is a reply.