Hola Jorge, first of all many thanks for sharing your tips.
On Mon, Jul 4, 2011 at 10:46 AM, Jorge Gonzalez <[email protected]> wrote: > > This is the full configuration for my model, which includes heavy caching > (it's a readonly access to a data warehouse which gets updated once a day): > > Model::MyDB: > traits: > - Caching > - SchemaProxy > default_resultset_attributes: > cache_for: 3600 # cache results for one our > connect_info: > dsn: 'dbd:mysql:host=1.2.3.4;database=test' > user: test > password: test [snipped] > With this configuration I didn't have to touch a single line where queries > were being executed. [snipped] > Regards > J. I have one question, though: I have a number of essentially static tables (very infrequent changes), and some tables that change a lot during a session (e.g. those that store data from the user's session, for persistency across logins). Is there a way to exclude specific tables from the caching? I've read the docs and I see I can specify the caching (yes/no, TTL) for every query being executed ... The problem is that i) I don't want to do this (I prefer your suggestion to turn on caching for all queriesI; and ii) the queries for which I'd like to turn off caching are not executed by me, but by the corresponding plugins (e.g. Session::Store::DBIC; Session::PerUser). Anyone has solved this? Suggestions welcome. -- fernan _______________________________________________ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/[email protected]
