On Fri, Nov 11, 2011 at 1:39 AM, yqpl <y...@poczta.onet.pl> wrote: > Nico Williams wrote: >> What's your page size? > > i have no access now to those files. but i didnt change any thing - so > default.
You really want to set the page size to something decent -- at least the filesystem's preferred block size (typically 4KB or 8KB). The page size has a lot to do with performance: a) it affects the number of meta-data nodes in the b-trees as well as the depth of the b-tree, which affects the number of reads needed to do random lookups or insertions, b) page sizes that are not whole multiples of the filesystem's preferred block size result in larger I/Os than the page size anyways because the filesystem will likely want to read the whole thing in. Nico -- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users