-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Martin.Engelschalk wrote: > However, i could not find a way to determine when the empty pages are > used up and the file will start to grow again without checking the file > size after every insert.
Doesn't PRAGMA freelist_count help with that? There is also PRAGMA page_count and another to determine page size so you can do all these calculations without going outside of SQLite. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAktPZtwACgkQmOOfHg372QRHEgCeKwRMG+DpI1Kq/2jeo/Iw/DO0 DtoAoIYIqt40E9TIWlebbYPta33S6o9r =pY6s -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
