Hello! On Monday 21 September 2009 15:05:04 Atul_Vaidya wrote: > 5. PRAGMA cache_size = 12000;
I use value 128 000 on servers. You must set pragma page_size=4096; If database is not empty is needed to vacuum it. > > i also avoid the update calls, and i do all the insertion in between Begin > Transaction and End Transaction.I was planning to call the insertion calls > to SQLite in a separate thread.I am using the SQLite Version 3.3.13.When i > dig in through documentation, the latest version was 3.3.18.FAQ says that > the SQlite is Thread safe. Please suggest me if I should work in this > direction. Last version is 3.6.18 and is more better to use this. But your version is thread-safe too. Best regards, Alexey Pechnikov. http://pechnikov.tel/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users