Hi! @sindharta:FYI my first name is Alexander, not Hartmaier ;-)
I rewrote the status page of my network monitoring app to use ExtJS which gets its data with JSON. As JSON is already a serialized representation of my resultset (and a very compact as well) I now cache that (with Cache::FastMmap at the moment) and it works fabulous! After forcing ExtJS to use GET instead of POST the roundtrip time went down from ~150ms to ~50ms too. -Alex -----Original Message----- From: Tobias Kremer [mailto:[EMAIL PROTECTED] Sent: Thursday, January 10, 2008 4:30 PM To: DBIx::Class user and developer list Subject: Re: [Dbix-class] Resultset with memcached Quoting Moritz Onken <[EMAIL PROTECTED]>: > 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. The MySQL query cache gets invalidated as soon as changes to a table occur thus using memcached instead of relying on the database query cache still makes perfectly sense in a lot of situations. --Tobias _______________________________________________ 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]
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________ 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]
