I can't check it out now, but my best bet would be the following:
a) do as I told in my prior email, so you specify caching strategy for
most of your tables with almost no effort.
b) for the tables wich you want to have a different caching policy,
modify the resultset_attributes parameter for that class in the Schema
class configuration (in the file part which is not rewritten when
regenerating the schema).
Please try :-)
J.
El 04/07/11, Fernan Aguero <[email protected]> escribió:
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]
