Comment 9 for bug 734642

Robert Collins (lifeless) wrote :

Huh, the original one returns 4 rows (on qastaging):
ids 206643309 215539313 192242823 215770253
and the doctored one returns
192242823 215539313 206643309 215770253

- the same ids.

I added with support to storm last week, it made component bug searches about 30 times faster.

The joins will constrain the rows to ones where the potmsg has a suggestion (because they are inner joins). I'm taking it on faith that they are needed because they were present in the original query I refactored.