When running a large (large SQLite DB file) vacuum I have problems with the Android OS killing the app or perhaps just the vacuum process.
I say "perhaps just the vacuum process" as sometimes the app is not killed but the vacuum has done nothing, meaning the size of the DB file has not reduced...
Have a large SQLite DB, file size is 4.9 Gb, this is according to B4A File.Size (In Windows it shows at about 4.5 Gb).
The file is in File.DirInternal.
I copied the file to external storage (after closing the DB connection) and then copied the file to my Windows PC.
I then did a vacuum in DB...