Message-ID: <471D2CA6.2030908@santafe.edu>
Date: 2007-10-22T23:05:10Z
From: Marcus G. Daniels
Subject: RSQLite indexing
In-Reply-To: <Pine.LNX.4.43.0710221557140.27183@hymn12.u.washington.edu>
Thomas Lumley wrote:
>> How big is your dataset? SQLite can be slow, but I didn't think it
>> was that slow.
>>
>
> 350000x100 entries on 12 variables
>
I had a similar problem a while back and took the opportunity to test
various RDBMS. I found that a product called TimesTen from Oracle was
the fastest, followed by Microsoft SQL server, followed by Oracle 10
Enterprise with bitmap indicies, followed by Postgres. RSQLite had
relatively poor performance and I had trouble persuading MySQL to
optimize the query at all. I did not try any column oriented database
systems like Sybase IQ or Vertica, which should do better for the
read-oriented workload.