Status

Webtools
DXR
P3
normal
5 years ago
4 years ago

People

(Reporter: erik, Unassigned)

Tracking

Trunk
x86
Mac OS X

Firefox Tracking Flags

(Not tracked)

Details

(Reporter)

Description

5 years ago
At least this type-ref query is unreasonably slow, about a minute long: http://dxr.allizom.org/search?q=type-ref%3Adrop&tree=mozilla-central

Take a look at the query plan. Maybe we're missing indices or something.

Comment 1

5 years ago
At the moment it's only 7 seconds for me. However I find that a bit slow, but if was bug 847580 fixed, the result might be good enough.
(Reporter)

Comment 2

5 years ago
7 seconds is still pretty ridiculous. We're almost certainly doing something dumb in the DB. :-)
(Reporter)

Comment 3

4 years ago
Down to 1.3 seconds now, but there's still a 38,000-row table scan in there: http://dxr.allizom.org/mozilla-central/search?tree=mozilla-central&q=type-ref%3Adrop&redirect=true&explain=true
You need to log in before you can comment on or make changes to this bug.