Dear SQLitees, I'm working on in-memory database and using SQLite 3.5.4 and I'm facing difficulties while deleting records from table. My table contains around 35K records, and it keeps on updating at regular intervals, the records may add or gets delete. And I have limited memory.
The problem i'm facing is after deletion of some rows, the memory won't get freed. I can't use AUTO_VACUUM also, as it is IN_MEMORY database. (And moreover autovacuum duplicates the PAGE and then rewrite the page afresh, which again consumes memory) What is the best way to achieve complete deletion? Is there any option not to use paging technique? Regards, *Lokesh*
