-
Committer:
MaaS Lander
-
Author(s):
Graham Binns
-
Date:
2014-12-18 14:37:12 UTC
-
mfrom:
(3329.3.3 fix-bug-1402237-1.7)
-
Revision ID:
maas_lander-20141218143712-z51grcip700t2hup
[r=rvb][bug=1402237][author=gmb] When fetching the non-debug events for a node, fetch the non-debug EventTypes first and then query the Event table using 'WHERE type_id IN <non-debug-EventTypes>'.
Previously, this query was the default Django-generated one, which did an INNER JOIN between Event and EventType. The new version is significantly faster, because there's an index missing on EventType.level which makes things slow at scale.