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.

Why is it doing that? Is there 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.