Think about Loose Coupling | |
PerlMonks |
Re^3: Architectural question...by raafschild (Novice) |
on Jul 05, 2005 at 21:04 UTC ( [id://472602]=note: print w/replies, xml ) | Need Help?? |
This certainly is a fruit of a different kind ;-). You might want to store the results of the query in a summary table and have that table maintained by a set of triggers on the data table. That way the persistence and the caching is handled by the database, so you don't have to write it yourself. Queries on this summary table should by quick, and all changes in the data table are immediately available in the summary table. Sorry for a not very perlish suggestion in this forum. Raafschild
In Section
Seekers of Perl Wisdom
|
|