Re: Sharing data structures in mod

Hmm, merlyn's node above made me think of this: what about using Matts' DBD::SQLite in-memory database driver? It's still pre-1.0, but if it works for you, it could be a big win. You could structure your data to reduce memory hits, it supports transactions so you can control access, and it appears to have decent performance under load. There is a benchmark at SQLite vs CDB_File vs BerkeleyDB. Might be worth a try.

Comment on Re: Sharing data structures in mod_perl

Replies are listed 'Best First'.
Re: Re: Sharing data structures in mod_perl by perrin (Chancellor) on Mar 28, 2002 at 17:06 UTC
SQLite is really not for multi-process use. It doesn't support much in the way of locking, not even to the point of the original MySQL stuff and certainly not as good as the new MySQL table types or PostgreSQL.	[reply]
Re: Re: Sharing data structures in mod_perl by Hero Zzyzzx (Curate) on Mar 28, 2002 at 16:30 UTC
I have checked it out a little. Pretty cool idea, I'll probably use it on a smaller project somewhere. I guess my thoughts are that if I'm going back to DBI queries anyway, I might as well run them against my MySQL server that's already storing the data. -Any sufficiently advanced technology is indistinguishable from doubletalk.	[reply]