Diego Jancic
Diego Jancic

Reputation: 7460

SQLite db size too big

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

Answers (1)

uthark
uthark

Reputation: 5363

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

Upvotes: 7

Related Questions