From: "M. Edward (Ed) Borasky" <znmeb@...>
Date: 2006-08-09T23:15:06+09:00
Subject: Re: Looking for a Fast Persistent Store

Harold Hausman wrote:
> Have you tried SQLite and found it to be too slow? It sounds to me
> like you might be prematurely optimizing. We have several medium to
> medium-large sized apps that make heavy use of SQLite and speed has
> been not a problem at all.
On Linux, at any rate, one ought to be able to make SQLite extremely 
fast by adding RAM and tuning the I/O subsystem and the kernel, and 
using tricks like memory mapped files, assuming the database in question 
isn't too large. I'm assuming it's small, otherwise he'd pretty much 
need a humongous database server and an industrial strength database 
like Oracle or PostgreSQL.