Posted by moshe weitzman on July 28, 2008 at 3:19pm
Jump to:
| Project: | Teleport |
| Version: | 6.x-1.x-dev |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | incidentist |
| Status: | closed (fixed) |
Issue Summary
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.
Comments
#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.