Last modified: 2012-12-14 21:03:29 UTC
Apply the one-liner patch at http://bzr.mozilla.org/bugzilla/4.2/revision/8176 to fix https://bugzilla.mozilla.org/show_bug.cgi?id=818007 After this has been done, the corresponding file in https://gerrit.wikimedia.org/r/gitweb?p=wikimedia%2Fbugzilla%2Fmodifications.git;a=summary needs to be updated too.
https://rt.wikimedia.org/Ticket/Display.html?id=4122
the patch as linked above just adds the DISTINCT keyword to a SELECT from the database on search. per https://bugzilla.mozilla.org/show_bug.cgi?id=818007 this improves search performance like this: --- David Lawrence [:dkl] 2012-12-04 14:07:59 PST Although not a massive improvement as others have reported, it does improve things somewhat on my test install of BMO 4.2 with DISTINCT: 1.89s 1.94s 1.89s ---- 1.90s average without DISTINCT: 2.07s 2.09s 2.10s ----- 2.08s average --- I added the DISTINCT in Bugzilla/Search.pm on kaulen.
and added a .gitreview file to the BZ modifications repo so that "git review" should now work and added the patched Search.pm file in the 4.2 directory https://gerrit.wikimedia.org/r/#/c/38751/
Thanks!