[Dbix-class] Resultset with memcached

Moritz Onken onken at houseofdesign.de
Thu Jan 10 12:50:11 GMT 2008


I think there is no big difference in speed between the query cache of  
a dbms like mysql and a memcache query.
Try disabling the query cache in your dbms to see the performance  
impact.

Moritz


Am 10.01.2008 um 10:48 schrieb Ash Berlin:

>
> On Jan 10, 2008, at 3:08 AM, <sindharta_tanuwijaya at yahoo.co.jp> wrote:
>
>>
>>
>> Actually, I think that the bottleneck in my case here is the time  
>> it takes to perform database queries. I haven't tried  
>> DBIx::Class::Cursor::Cached yet, but looking at the posts, it seems  
>> more appropriate for me than  Cache::Memcached. Any thought how  
>> long a value will stay (valid) inside the cache in  
>> DBIx::Class::Cursor::Cached ?
>>
>> Sindharta
>>
>
> How ever long you tell it to:
>
> $rs->search($cond_hash, { cache_for => 300 } ) # Cache for 300  
> seconds.
>
> -ash
>
> _______________________________________________
> 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/dbix-class@lists.rawmode.org




More information about the DBIx-Class mailing list