remove LOWER from alias query
moshe weitzman - July 28, 2008 - 15:19
| Project: | Teleport |
| Version: | 6.x-1.x-dev |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | incidentist |
| Status: | closed |
Jump to:
Description
I think the LOWER in the alias query buys us a little compared to the performance hit it costs (no index is used). The other LOWER instances are more valuable.
#1
I turned "LOWER(dst)" into "dst" but kept the "LOWER('%%%s%%')". I think that removes the performance hit, since the alias index can be used, while still reducing capitalization issues.
#2
#3
Automatically closed -- issue fixed for two weeks with no activity.