[Dbix-class] Caching solutions for DBIx::Class

[Fernan Aguero]

Hola Jorge,

first of all many thanks for sharing your tips.

On Mon, Jul 4, 2011 at 10:46 AM, Jorge Gonzalez
<jorge.gonzalez at daikon.es> 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