Tens of databases (from a few MBs to almost GB), so it's good to keep them
at their minimum size (for disk and backup savings).
I often save several megabytes by going to the 'right' size, eg., just today
I went from ~110MB down to ~80MB in one of them ('vacuum'ed before and after
so it's just the page size making this difference). Sometimes, very small
page sizes give best results, sometimes the other way around.
Some databases do well in the same page size as new data is added, but for
some others you need to recalculate as their content changes.
Still, you can't know in advance which ones can do better unless you
actually try it. And, that's the main problem.
I have to try with ~100 DBs to get a significant benefit in just a few of
them (about 5-10), until next time.
Anyway, I thought I'd ask.
-----Original Message-----
From: David Raymond
Sent: Wednesday, July 31, 2019 10:48 PM
To: SQLite mailing list
Subject: Re: [sqlite] Quick way to determine optimal page size?
Not that I'm aware of no. How much of a difference are you seeing for your
database size depending on the page size you try?
-----Original Message-----
From: sqlite-users <sqlite-users-boun...@mailinglists.sqlite.org> On Behalf
Of Tony Papadimitriou
Sent: Wednesday, July 31, 2019 3:29 PM
To: General Discussion of SQLite Database
<sqlite-users@mailinglists.sqlite.org>
Subject: [sqlite] Quick way to determine optimal page size?
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?
Thanks.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
