Self-Introduction: Fergus Sullivan

Olav Vitters olav at bkor.dhs.org
Wed Aug 29 19:57:32 UTC 2007


On Wed, Aug 29, 2007 at 11:31:33AM -0700, Fergus Sullivan wrote:
> == Full name ==
> Fergus Sullivan

Welcome!

> Speed
>  - The core SQL within Bugzilla did not scale to meet our needs.  We 
> reached a tipping point at around 800,000 bugs.  The main cause was lock 
> contention within the DB.  The causes and solutions would fill an academic 
> paper.  We rewrote search.pm and greatly increased performance.  Some of 
> the changes were trivial.  A two line change improved our "search for bugs 
> where person X is cced" from 45 seconds to 0.4 seconds.  Other changes were 
> vast.  The overall effect was search times have dropped from up to 45 
> seconds in typical usage to about six seconds.

I'm very interested in all speed improvements.

> Product Management
>  - With 2,400 different products, the vanilla product chooser does not 
> scale for us.  We have built an entirely different version.
>
> UI
>  - We have made many minor and a few major changes to the UI.  One 
> interesting one is the use of a JavaScript datatable for client-side 
> sorting of buglist results.  This greatly reduces server load.

Please push upstream!

>  - We have unified comments and the bug activity table.  Both appear inline 
> in the show bug page.

Same, very welcome upstream.

>  - We are making increasing use of the YUI library.  These allow our 
> fancier functions to work on all platforms.

No idea what that is.

-- 
Regards,
Olav



More information about the developers mailing list