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

Reply via email to