[Dbix-class] How to arrange common-cache result sets
Michael Gray
mjg17 at eng.cam.ac.uk
Wed Jun 7 15:50:38 CEST 2006
I'm hoping a quick(?) query now will save me some time and digging.
I have a number of tables in my application which are essentially lookup
tables. These are slow-changing but not static. An example is 'domain'
which contains valid domains for the site
10 => eng.cam.ac.uk
20 => vlan.eng.cam.ac.uk
etc.
What I'd like to do is set up my DBIC schema class for such a table such
that there's a common cache, and that a call to
schema()->resultset('domain')
returns a resultset which makes use of the common cache. How might I
best go about this?
At the same time, I'd like to arrange that any insert, delete or update
on 'domain' invalidates the common cache. What are the best hooks for
doing this?
Thanks in advance for any pointers.
--
Michael
More information about the Dbix-class
mailing list