Re: [Rd] RSQLite indexing

From: Marcus G. Daniels <mgd_at_santafe.edu>
Date: Mon, 22 Oct 2007 17:05:10 -0600

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.



R-devel_at_r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-devel Received on Mon 22 Oct 2007 - 23:09:39 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Thu 25 Oct 2007 - 11:37:11 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-devel. Please read the posting guide before posting to the list.