The database size that we use in the application can grow upto 50 GB. We have an option of shrinking the database using the Vacuum command. I understand that Vacuum command consumes lots of time to execute,but i dont see any other way.
I wanted to know what is the good way to execute Vacuum command. - Inside a transaction or without transaction? - What would happen if we terminate the Vacuum command in-between when its not executed in a transaction? Does the database gets corrupted if we stop/kill the operation inbetween? -If we put inside a transaction, definitely we would get a SQLITE_BUSY error.Any way to avoid this error? Thanks in advance. Veeresh _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users