Hello, [...]
deleting PRAGMA foreign_keys = ON; led to a miracle: everything completed after 30 minutes. Because of the enormous difference (~ 24h without finish compared to 30 minutes) I can imagine that there are ways to otimize the speed with the use of FKs - but that seems to be a question only the programmers can answer. Oliver _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users