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
