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, com开发者_开发百科ments 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 ?

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

Try to clean up (vacuum).