--- [EMAIL PROTECTED] wrote:
> But as people start to push SQLite
> into the 100GiB size and beyond, we will likely revisit
> that decision.
Just curious if anyone has experience with such large sqlite databases.
How much RAM do these machines have that produce 100GB+ databases
and what kind of media are they storing it on - spinning hard drives
or RAM drives?
Do such installations make use of multiple indexes per table
for their large tables?
Are you aware of any sqlite3 user with, say, a heavily indexed
100GB database produced by a machine with only 2GB RAM?
And how is the INSERT and SELECT performance relative to a 1GB database?
____________________________________________________________________________________
Never miss a thing. Make Yahoo your home page.
http://www.yahoo.com/r/hs
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
