From: Bob Hutchison <hutch@...>
Date: 2006-08-10T00:10:33+09:00
Subject: Re: Looking for a Fast Persistent Store


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.

Cheers,
Bob

----
Bob Hutchison                  -- blogs at <http://www.recursive.ca/ 
hutch/>
Recursive Design Inc.          -- <http://www.recursive.ca/>
Raconteur                      -- <http://www.raconteur.info/>
xampl for Ruby                 -- <http://rubyforge.org/projects/xampl/>