CODEWITHSUNDEEP
databasesqlite
AntonAL
AntonAL

Reputation: 17410

sqlite3 database file size problem

i have sqlite3 database file, that is back-end of a blog.

The blog has about 20 articles right now and no BLOBs are stored, just posts, comments etc.

The size of file should be about 1 Mb, but in reality, it is 470 MB.

Why it is so huge ?

How can i find places, eating up space ?

Upvotes: 1

Views: 217

Answers (1)

TomaszK
TomaszK

Reputation: 435

Have you been doing a lot of inserts and deletes? :)

Try to clean up (vacuum).

Upvotes: 3

Related Questions