Edgewall Software

Changes between Initial Version and Version 1 of Ticket #8519, comment 9


Ignore:
Timestamp:
Dec 23, 2009, 12:01:56 PM (12 years ago)
Author:
Christian Boos

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #8519, comment 9

    initial v1  
    11Replying to [comment:8 cboos]:
    2 > Well, I expect the speed should be in the same league with the explicit comparison than with the "between", as it will also be able to make good use of the index.
     2> ... So my next suggestion would be to drop the idea of separate `like()` and `ilike()` altogether, and keep `like()` case-insensitive.
    33
    4 Verified. It's funny that such a simple trick would bring three orders of magnitude of improvement.
    5 
    6 The other interesting thing is that this reduces the need for a case-sensitive `like()` to... no occurrences at all! So my next suggestion would be to drop the idea of separate `like()` and `ilike()` altogether, and keep `like()` case-insensitive.
     4Ha! Lazyness attack! But I have to agree, let's defer making the `like`/`ilike` distinction to when it becomes really needed. If not already done, we should also make sure the docstring for `like()` correctly highlights its case-insensitiveness.