Self-Introduction: Michael Leupold

[Michael Leupold]

On Friday 23 January 2009 00:59:20 Max Kanat-Alexander wrote:
> On Wed, 14 Jan 2009 23:35:05 +0100 Michael Leupold <lemma at confuego.org>
> wrote:
> > Lately our Bugzilla has been hit by some performance issues when
> > doing substring searches (using MySQL, often tens of seconds before
> > the search finishes)
> 	If you're using the built-in fulltext in Bugzilla 3.0, it's
> slow. You should try Bugzilla 3.2.

I tried CVS locally but didn't experience a lot of speedup.

> > One thing I came up with is extending the search mechanism to allow
> > for external fulltext search engines to be implemented and used.
> > [snip]
> 	We've talked about that before, but we didn't do it because a
> separate fulltext engine can only do searches on fulltext, not fulltext
> + normal fields. So it'd be hard to implement, say, boolean charts
> using that, in any efficient way.

I've implemented it using the Sphinx fulltext search engine. It's pretty handy 
because it can do searches with arbitrary infix (proper substring) and still 
fast. The only disadvantages it has are that integrating it into the Bugzilla 
search needs you to submit a big WHERE bug_id IN (...) query which - albeit 
the size - works pretty well if you up mysql's maximum query size.

Here's a benchmark I did: http://www.confuego.org/archives/13-Improving-
Bugzilla-search-speeds.html

> > - Define a new Hook so supplemental search modules can be defined in
> > extensions.
> 	That'd be handy. We were looking into ways to do that--we might
> want more re-arch of Search.pm before we actually add it upstream,
> though.

I submitted my patch as: https://bugzilla.mozilla.org/show_bug.cgi?id=474095

> > 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.
> 	Cool. Feel free to get in touch with us on IRC.

Basically I am already hanging around there :)

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/20090123/114fb73b/attachment.sig>