We ran into an issue where specific queries are geting non linearly slower when the total number of tables grows.
Example 1 (not slow): Database has table A Database has 1,000 other tables with foreign key to table A Row is deleted from table A (no deletion of actual data in other tables is involved). Example 2 (more than 50 times slower than example A): Database has table A Database has 10,000 other tables with foreign key to table A Row is deleted from table A (no deletion of actual data in other tables is involved). Does anybody have an idea why the preparation time of the query is scaling up so fast in the above examples? Best regards, Harmen de Jong CoachR Group B.V. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
