Skip to content
Prev 26476 / 63424 Next
Original Raw

RSQLite indexing

Marcus G. Daniels
Thomas Lumley wrote:
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.

Thread (8 messages)

Thomas Lumley RSQLite indexing Oct 22 Hadley Wickham RSQLite indexing Oct 22 Thomas Lumley RSQLite indexing Oct 22 Jeffrey Horner RSQLite indexing Oct 22 Marcus G. Daniels RSQLite indexing Oct 22 Kasper Daniel Hansen RSQLite indexing Oct 22 Seth Falcon RSQLite indexing Oct 22 Kasper Daniel Hansen RSQLite indexing Oct 23