> You must set pragma page_size=4096; Can I ask why "must" and this number? Why not the maximum 32768?
Pavel On Mon, Sep 21, 2009 at 11:45 AM, Alexey Pechnikov <pechni...@mobigroup.ru> wrote: > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
