How do you compact DB?

[stone77]

Hi

I deleted some BLOB data and db size is still huge and was looking at compacting the database at runtime(during initialisation at start) Does anyone know how to compact the working copy of the database?  Ive tried using Vacuum command, which does compact but it creates a copy (saves with a .save-journal extension) which I dont want. I can use the compact command using DB browser but its not a solution as I need to do this through unity at runtime.


Best Regards

Stoneh

[echo17]

I just saw this post and didn't get an email notification, sorry for the long delay.

After calling VACUUM, you can delete the copy manually using .NET file commands like File.Delete(), if you don't want the copy database. I'm not sure why sqlite library makes this copy, seems kind of pointless.