Re: general design issue
Date: Thu, 23 Apr 2009 18:28:02 -0300
> Bob Badour write:
>>Other than being non-standard, what is your objection to using GLOB >>'prefix*' ?
> i'm sorry i overlooked GLOB in the previous post. ok gave it a try on
> my sqlute and results are the same as LIKE: ~1200 ms...
How many distinct items with the same prefix do you have? Presumably you have no more than about a couple dozen with the same prefix plus one character.
Are the prefixes you use always the same length? Received on Thu Apr 23 2009 - 16:28:02 CDT