Search.pm SQL queries

[Michael Leupold]

On Wednesday 25 February 2009 23:06:32 Max Kanat-Alexander wrote:
> On Wed, 25 Feb 2009 23:00:05 +0100 Michael Leupold <lemma at confuego.org>
> wrote:
> > Unfortunately like this it's still not possible to move the actual
> > query condition $term into a WHERE clause which is what I tried to
> > achieve in the first place.
> 	Yeah, I wouldn't worry too much about optimization at this
> point. That would be a separate bug from the one you linked to, anyhow.
> If we want to move things into the WHERE clause in a way that works
> with NOT(), we'd have to re-work every function inside Search.pm, I
> think. It might be possible, but it's something to be careful of and
> that requires its own bug.

Actually I was just considering what I put into c#1 of that bug (476722). 
Separating the join and the search term would allow for more generic joins. 
After looking through all of the search functions this seems fairly 
unrealistic though.

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/20090226/ec8b07cc/attachment.sig>