On 4 Jul 2012, at 10:54 AM, Hauptmann Peter <[email protected]> wrote:
> However, VACUUM is by far requiring the most time, and with most uncertain > results > (i.e. whether or not it improves subsequent performance). VACUUM exists only to release unused space from the database file. If you have been entering new data and not deleted old data it will do nothing usefull unless your OS is sensitive to fragmentation (i.e. Windows). Provide your users with a way to do it so you can, during a support call, decide it might help. Don't bother doing it on a regular basis. Simon. -- Sent from my iPhone _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
