For some reason that didn't apply cleanly using "patch", but I applied it
manually.

It definitely sped things up, and the results are the same as those
returned by the long-running query.  Went from 218 seconds to .2 seconds.

The real test will be when I re-create this, because in my attempt to
improve things I also created several indices and ran "analyze" on the
database.  All were to no avail with the previous queries, but they may
have had an effect on this query.

I expect a similar change may need to be made for the called-by as well?


-- 
Chris Cleeland
_______________________________________________
dev-static-analysis mailing list
[email protected]
https://lists.mozilla.org/listinfo/dev-static-analysis

Reply via email to