interesting. thanks for the tip. I"ll give it some consideration.
-James On Apr 21, 2008, at 1:07 :50PM, Scott Hess wrote: > If you create a file on disk and set PRAGMA synchronous = OFF, you > should get pretty close to the performance of a shared in-memory > database on most modern desktop operating systems - maybe close enough > that you won't care to do anything beyond that. If you further look > at the recent discussion/patch to disable journaling entirely, you > should get even closer. Going this route means you won't have to > worry so much about the case where someone accidentally pumps 4 gig of > data into your database and sucks up all RAM. > > Keep in mind that if you do these things, then it is quite trivial to > generate corrupt database files if your app or OS crashes. So you > need to arrange to delete database files on app start-up to reset your > state (an in-memory database wouldn't have that problem!). On a > Unix-based system, you may be able to open the database then delete > the underlying path, but that may not work for however you are sharing > things. > > -scott _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
