On Fri, Aug 13, 2010 at 1:38 PM, Max Vlasov <max.vla...@gmail.com> wrote:
> > I can approximately calculate, how big the new database will grow. Is >> there a way to tell SQLite to reserve an inital space or numer of pages >> instead of letting the database file grow again and again? >> > > > Thought about this recently. Another idea is to tweak VFS. Since xWrite > method is supposed to accept iOfst that is bigger than the current file > size, one can check whether the new write query is going to allocate new > space for the file (vs internal space writing), and before actual call make > prior call of the same function writing for example a single zero byte a > little far and after that perform the original request. Took not so much time to try it, the good news is that the tweak technically works (thanks to the flexible VFS sqlite uses), the bad news is that it gives no significant improvement, at least on Windows XP, both FAT32 and NTFS, only in some specific cases a little difference was noticeable. Max _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
