Hello, I have recently taken over a position that uses a SQLite database. The database is currently 24GB and running extremely slow. Is there a quick way to archive data and free-up some space? Also, are there any risks to running the "vacuum" command...such as losing data? I would like to archive a year's worth of data. Archiving the data via the application is taking roughly 30min for every 3-5MB. Unfortunately our application cannot be down for such an extended time to Archive the years worth of data we need.
SQLite Version: 3.6.23.1 Thanks, Jimmy Martin _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users