[Catalyst] Duplicate entries with C::P::Session::Store::DBIC and MySQL - new findings

Jonathan Rockway jon at jrock.us
Fri Sep 5 06:07:14 BST 2008


* On Wed, Aug 27 2008, Tobias Kremer wrote:
> Quoting Daniel Westermann-Clark <dwc at pobox.com>:
>
>> On 2008-08-26 14:18:18 +0200, Tobias Kremer wrote:
>> > Just out of pure curiosity: Why is it that there are dedicated
>> > "flash:<hash>" entries in the storage for the flash? Wouldn't the
>> > session be enough?
>>
>> The "flash:" rows were used for compatibility with Store::DBI.  We can
>> break compatibility if people find the it not very useful.
>
> We definitely should! IMHO five queries per request to the database just for the
> session and flash stuff is inacceptable.

If your app is really slowed by the number of queries to load
session/flash, use this:

http://git.jrock.us/?p=Catalyst-Plugin-Session-HMAC.git;a=blob;f=lib/Catalyst/Plugin/Session/HMAC.pm;hb=HEAD

Regards,
Jonathan Rockway

--
print just => another => perl => hacker => if $,=$"



More information about the Catalyst mailing list