Tou haven't said what "really slow" means. Could be multiple solutions to that problem.
30min for 3-5MB sounds a bit ridiculous. What kind of select are you doing to archive and what indexes are on the tables? -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Jimmy Martin Sent: Tuesday, January 08, 2013 8:05 AM To: [email protected] Subject: [sqlite] Archive SQLite Database? 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 [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
