On 31 Jul 2019, at 8:28pm, Tony Papadimitriou <to...@acm.org> wrote:
> Instead of brute force “pragma page_size=xxx; vacuum;” for each page size and
> each database to determine which one produces the smallest file, is there
> some quicker way?
It might be faster to
make a new file,
set page size,
ATTACH the old file,
and use the
INSERT INTO ... (SELECT * FROM)
syntax to make new database files rather than repeatedly use VACUUM to
reorganise the old one. Once you know which pagesize gave the best result, you
can delete the old one.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
