The reason why I asked is that I haven't had much luck with sqlite3 performance for databases larger than the size of RAM on my machine regardless of PRAGMA settings.
Maybe querying speed is fine for multi gigabyte database files, but INSERT speed into tables with multiple indexes is slow when you exceed the RAM threshold, so I did not pursue it. I guess the answer is to get more RAM - it's cheap. ...and use a 64 bit OS. High speed non-volatile RAM drives will be commonplace soon enough and alleviate this problem. --- Tom Briggs <[EMAIL PROTECTED]> wrote: > Heh, no, I've never tried, but I don't see much reason why I > couldn't. I was just trying to make the point that labeling SQLite as > "good ... for smaller databases" was not a slight. > > -T > > > -----Original Message----- > > From: Joe Wilson [mailto:[EMAIL PROTECTED] > > Sent: Thursday, December 13, 2007 11:51 AM > > To: sqlite-users@sqlite.org > > Subject: RE: [sqlite] SQLite and Columnar Databases > > > > --- Tom Briggs <[EMAIL PROTECTED]> wrote: > > > For clarity, my definition of small is about 200GB, so I'm not > > > selling SQLite short here... > > > > Are you able to get decent performance out of sqlite3 for a > > 200GB database? > > > > How much RAM do you have on such a machine? ____________________________________________________________________________________ Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
