Reputation: 7460
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) ?
Upvotes: 6
Views: 5387