Self-Introduction: Michael Leupold

[Michael Leupold]

Hi there,

as this is my first post to this list I'd like to introduce myself briefly.
My name is Michael Leupold (lemma on IRC) and I'm from Karlsruhe, Germany.

As a member of a team in KDE that triages bugs in our bugzilla installation 
(bugs.kde.org, currently 3.0, soon 3.2) I have used Bugzilla quite a bit, 
albeit rather from a user's perspective than from an administrator's one.

Lately our Bugzilla has been hit by some performance issues when doing 
substring searches (using MySQL, often tens of seconds before the search 
finishes). Unfortunately that features is needed a lot as we often have to 
search for related bugs/duplicates (eg. by symbols in the backtrace). I've 
been doing some benchmarking on wether 3.2 and InnoDB would improve 
performance but I didn't manage to exceed the results I had previously 
gathered. So I began browsing the Bugzilla code and checked for ways to 
improve performance.

One thing I came up with is extending the search mechanism to allow for 
external fulltext search engines to be implemented and used.

Things I did so far:
- Define a new Hook so supplemental search modules can be defined in 
extensions.
- Implement most of the search operators (that make sense, eg. allwordssubstr, 
substring, matches, ...) in an extension using Sphinx fulltext search.

All of this is only proof of concept so far but first benchmarks already show 
an enourmous gain in speed.

Unfortunately my knowledge of Perl is currently pretty limited as I only 
started last week. I do however hope that I'll be soon able to submit a patch 
for discussion/review.

Kind regards,
Michael
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part.
URL: <http://lists.bugzilla.org/pipermail/developers/attachments/20090114/169f7cd7/attachment.sig>