You can also just copy the entire file (best to do when app is not running). So you'd only be down for as long as it takes to copy it. If your database is updated frequently .backup may never finish.
Then you can archive from the copy and delete the archived rows from the active DB in a non-interference way (i.e. small batches). I still think you may benefit greatly from some indexes but we need more info. Somebody will eventually tell you to run EXPLAIN on your queries so we can see what they are doing. http://www.sqlite.org/eqp.html _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
