On Fri, Sep 6, 2013 at 1:29 PM, Harmen de Jong - CoachR Group B.V. < har...@coachr.com> wrote:
> On 6 sep. 2013, at 18:42, "Igor Tandetnik" <i...@tandetnik.org> wrote: > > 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. > > Ok, maybe that explains it. Do you remember some topics or explanations > that cover this more in depth? At least it will be worth for us to do some > debugging on the SQLite code to see if we can pin point this behaviour and > see if we can work around. Dr. Hipp does a little bit of explaining on this topic, generally, in his replies on this thread: http://www.mail-archive.com/sqlite-users@sqlite.org/msg78602.html -- -- -- --Ô¿Ô-- K e V i N _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users