On Fri, 2005-07-08 at 12:35 -0700, Bill Whillers wrote: > 1. What do you consider "simple hash-like operations"? - The target > application currently stores single hashes, lists, etc. as 1 per column with > 1 row per user (i.e. "select * from tbl where u=user") - RO's sit within a > single column.
I tested it using SQL like "SELECT value FROM table WHERE key = ?", using DBI best practices like prepare_cached() and bind_cols(). The contents of the value column were a hash serialized with Storable. > 2. With combined application/web servers balanced and moving the db to a > locally networked location is this still at least roughly the case? Yes, still pretty fast and faster than every CPAN cache/IPC module except Cache::FastMmap, BerkeleyDB, and IPC::MM. - Perrin
