[sqlite] Re: very large database file

[Will Leshner]

After analyzing my database I see that the average entry size is 381
bytes, which is over the recommended 230 bytes. The average unused
bytes per entry is 961. Also, there are about 80000 entries and about
100% of them overflow and about 85% of the overflow pages are unused
space. I'm wondering if this kind of a database, which is made up of
one table with about 20 fields, most of which are doubles, might do
better in SQLite 3?