Quote:
Originally Posted by davidfor
I haven't seen that before. SQLite does the compress by exporting the database and then reimporting it to a new database file. That would usually produce a smaller file. The only thing I can think of is if the database allocated some free space in the tables. That is done to make adding data faster. If this is happening, then an increase in space would be because some of that free space had been used.
|
FWIW I had a backup of the database before compressing so I opened it with SQLite Expert and ran "vacuum" on it. It went from 84.092MB to 83.35MB. I don't know if that tells us anything other than it was possible to squeeze it a little bit.
Not worth worrying about but interesting all the same.
BobC