Eric Sammer wrote:
Any DBM file or shared memory caching will be infinitely faster than making a DB round trip.
Actually, it turns out that this is no longer true. MySQL is really fast these days. A simple query on a local MySQL is faster than just about anything except IPC::MM or BerkeleyDB (using built-in locking).
I suppose that's true. I was also taking into account (potential) network lag if the rdbms is running on another box. Of course, I was also trying to be rdbms agnostic, to be fair. ;)
I've been running with postgres for most of our recent projects, but most of them have to run with just about anything that DBI uses so having a caching layer helps. I've noticed a sizable increase in performance when testing with ab and jmeter. Also, according to Apache::DProf, things are running smoother.
MLDBM::Sync is still fast enough for most uses, and faster than a complex query (joins or multiple items in the WHERE clause) on most databases.
I've had fantastic luck with MLDBM::Sync thus far, not that it's the all in one wonder tool.
-- Eric Sammer [EMAIL PROTECTED] http://www.ineoconcepts.com
-- Reporting bugs: http://perl.apache.org/bugs/ Mail list info: http://perl.apache.org/maillist/modperl.html
