perl-modperl mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bill Moseley <mose...@hank.org>
Subject Re: Comparison of different caching schemes
Date Tue, 18 Dec 2001 22:01:21 GMT
Ok, I'm a bit slow...


At 03:05 PM 12/12/01 +1100, Rob Mueller (fastmail) wrote: 

>>>>

<excerpt>Just thought people might be interested...

</excerpt><<<<<<<<

Seems like they were!  Thanks again.


I didn't see anyone comment about this, but I was a bit surprised by
MySQLs good performance.  I suppose caching is key.  I wonder if things
would change with 50 or 100 thousand rows in the table.


I always assumed something like Cache::FileCache would have less overhead
than a RDMS.  It's impressive.



>>>>

<excerpt>

  

Now to the results, here they are.

 Package C0 - In process hash

Sets per sec = 147116

Gets per sec = 81597

Mixes per sec = 124120

Package C1 - Storable freeze/thaw

Sets per sec = 2665

Gets per sec = 6653

Mixes per sec = 3880

Package C2 - Cache::Mmap

Sets per sec = 809

Gets per sec = 3235

Mixes per sec = 1261

Package C3 - Cache::FileCache

Sets per sec = 393

Gets per sec = 831

Mixes per sec = 401

Package C4 - DBI with freeze/thaw

Sets per sec = 651

Gets per sec = 1648

Mixes per sec = 816

Package C5 - DBI (use updates with dup) with freeze/thaw

Sets per sec = 657

Gets per sec = 1994

Mixes per sec = 944

Package C6 - MLDBM::Sync::SDBM_File

Sets per sec = 334

Gets per sec = 1279

Mixes per sec = 524

Package C7 - Cache::SharedMemoryCache

Sets per sec = 42

Gets per sec = 29

Mixes per sec = 32

  

</excerpt>



Bill Moseley

mailto:moseley@hank.org

Mime
View raw message