From: "Kroeger, Simon (ext)" <simon.kroeger.ext@...>
Date: 2006-08-10T00:16:43+09:00
Subject: Re: Looking for a Fast Persistent Store

 

> From: Bob Hutchison [mailto:hutch@recursive.ca] 
> Sent: Wednesday, August 09, 2006 4:39 PM
> 
> > 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.
> 
> In the Java world things like Perst and JDBM were very fast. SQLite  
> was problematic for some reason that is a bit foggy just now (I'll  
> think of it).

All I can say is SQLite3 was amazingly fast at solving every problem
I threw at it (I don't know for the ruby bindings, but they appear
to be relativ thin).

I have to admit though that I never had more than a few 100 thousand
items in a single table.

Being blessed with the power and speed of complex SQL statements is 
invaluable especialy in a scripting language.

cheers

Simon