On 9/6/2013 10:35 AM, Harmen de Jong - CoachR Group B.V. wrote:
We ran into an issue where specific queries are geting non linearly slower when the total number of tables grows.
If I recall correctly, query planner's behavior is worst-case quadratic in the number of tables participating in the query. This includes tables mentioned directly, and also those pulled in indirectly via views, triggers or foreign keys.
If I may be so bold, I would say that a design that calls for a database with 10,000 tables doesn't feel right to me.
-- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
