I was looking into the filters case sensitivity issue at http://drupal.org/node/162695 which acquainted me with how the 'like' filter views_handler_filter_like() works.

Could I suggest that all the UPPER() functions be removed? This will give a big performance gain, particularly in light of comments at http://drupal.org/node/162695#comment-283182. It will revert the query to a direct indexed lookup rather than using a computed column.

IMHO case distinction is best left to the database, as per collation sequences or however case sensitivity is configured on the relevant database.

This change can be sold as a benefit, because you're giving the application programmer / DBA control of the case sensitivity of the default handlers without code changes or creation of new filters. It's more transparent and in line with the move of D6 towards DBMS independence.

Comments

sun’s picture

sun
Primary language German
Location Karlsruhe
commented
Status: Active » Closed (won't fix)

Sorry, unfortunately this support request is way too specific. Please have a look at the issue queue - Views maintainers are buried already. You might want to try to get further support at http://drupal.org/support.
If you were able to solve this issue on your own in the meantime, you might want to add the involved steps to this closed issue, so other users searching for a similar solution might find it.