I just saw perrin's post on perlmonks -- can't remember my login/pass for there
just wanted to clarify - i said that it was closer to the speed of bdb than mysql -- not faster than bdb
most of my tests have been with selects though -- i routinely use it as a way to store/retrieve certain types of content or configuration directives that change less often than stuff i store in mysql, but are read on most page views , and not really for 'session' type constant reads/writes
On Mar 15, 2005, at 2:48 PM, Perrin Harkins wrote:
SQLite2 was pretty slow when I benchmarked it for simple hash-like usage. MySQL beat it by miles. If the new one is faster, I'll have to try my benchmarks again. Does it do anything fancier for concurrency than locking the whole database like the older versions did?
