FullText Searching: The Dilemma
bbaetz at acm.org
Wed Jun 27 00:03:53 UTC 2007
On 27/06/07, Max Kanat-Alexander <mkanat at bugzilla.org> wrote:
> On Wed, 27 Jun 2007 09:30:33 +1000 "Bradley Baetz" <bbaetz at acm.org>
> > Postgres supports functional indexes. So you create an index on
> > UPPER(column) and then a search WHERE UPPER(column) = 'FOO' will use
> > the index.
> Yes, I know. We use those already in a few cases. The problem
> isn't that--the problem is modifying all of Bugzilla to use
> $dbh->sql_istrcmp, which would also be ugly and hard to maintain.
Where apart from Search.pm needs to be changed, though? And even then
most of those sort of queries can be made to be fulltext queries
Most other things (eg group names, email addresses) could be case
folded on input, although people may not like that for emails.
More information about the developers