SQLite db size too big.

Question

I'm creating a DB using SQLite from .NET, and then inserting 1500 records (15 columns, only 3 with information). At this point the database file size is 73mb!! (huge for the amount of information involved).

If I open SQLite Administrator, and do a Clear Database, it shrinks to only 142kb.

What it's doing that? Anyway to avoid it? Either way, is there a way to shrink the DB file from .NET (I'm using System.Data.SQLite, which uses Finistar under the hood)

Answer 1

Yes, you can execute VACUUM and REINDEX on the database in order to shrink its size.