Re: [sqlite] Row count in database

[amead]

Christopher Petrilli wrote:
Has anyone had any experience in storing a million or more rows in a
SQLite3 database?  I've got a database that I've been building, which
gets 250 inserts/second, roughly, and which has about 3M rows in it. 
At that point, the CPU load is huge.

Note that I've got syncing turned off, because I'm willing to accept
the risks.
Thoughts?  

Chris
 

I have a database with almost 1.4 records in one table and over half a 
million in another.  I treat them like they are read-only so I cannot 
advise you about write performance except to urge you to read the 
document on www.sqlite.org about performance...  I do notice that doing 
anything like creating an index takes a while, as do joins.  When I do, 
I hear my variable speed fan rev-up, so the load is definitely higher...

Here's a silly idea:  If you have enough RAM and you don't care about 
sync'ing then could you run things in memory... like on a RAM disk or 
buy one of those RAM hard-drives?

-Alan
--
Alan Mead - [EMAIL PROTECTED]
People often find it easier to be a result of the past than a cause of
the future.