is there a way to compress the SQLITE3 database while indigo is running?
I am at 45+ GBYTE now and things are getting slow (Sql plugin takes 15 minutes to finish at startup)
Old data has been pruned, but the size has not changed, as expected. Can I do a "vacuum" command while indigo is running?
Or I could do a database dump and rebuild, but that will take many hours, but I would like like to loose several hours of data.
thanks
Karl