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]