FullText Searching: The Dilemma
mkanat at bugzilla.org
Tue Jun 26 23:31:01 UTC 2007
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.
Remember, MySQL *doesn't* support functional indexes, and
*won't* use a normal index on LOWER(col) = 'blah';
Competent, Friendly Bugzilla Services. And Everything Else, too.
More information about the developers