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, <[EMAIL PROTECTED]> 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/[EMAIL PROTECTED]


_______________________________________________
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]

Reply via email to