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

Bob Hutchison wrote:
>
> On Aug 9, 2006, at 10:15 AM, M. Edward (Ed) Borasky wrote:
>
>> 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.
>>
>
> A few GB max for one set of applications, far far less for others.
A few GB ... I'd be looking at a "real database" for that. "Pay me now 
or pay me later", as the saying goes. :)