Thanks Simon, Jim and Tom for your replies! @Simon: I don't have a problem per se with things running overnight, as long as I can be sure that things will complete at some point...the result of "PRAGMA integrity_check;", which by the way took less then an hour, is "ok". Any suggestions?
@Jim: I'm running your alternative query right now, but so far (after a couple of hours) seems to have the same symptoms: cpu jumps at first, a journal file is created, but then cpu usage drops to almost nothing and keeps decreasing, and no observable changes to the database file. @Tom: you are right, the version I posted removes only the "reverse copies" but leaves the rest in, which is another operation I need to do, and I mixed up the code when posting. To get the result I initially described, I would indeed use an "intersect" as you suggested. Sorry for the confusion. Rense _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
