Unnikrishnan Nair wrote:
Well, I deleted the rows, droped the index and did a vacuum on the table and nothing happen. I still have the file size as 198M. Is there anything else I am missing?
I've run into this myself. It's as if VACUUM decideds, for some reason, it can't do its job and bails. But I seem to recall a recent checkin about VACUUM. What version of SQLite are you using?