On 24 Jan 2012, at 7:09pm, David Garfield wrote: > no, it is more handwaving. The dirty marking you describe will be > done for a partial page at the old end of the file. Any additional > pages will normally be left unallocated, and the operating system will > provide zeros at read time when you try to read them.
Yes, but SQLite allocates pages in order, one by one. It doesn't take advantage of the ability to allocate files sparsely. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
