Re: general design issue
Date: Thu, 23 Apr 2009 18:28:02 -0300
>>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
Are the prefixes you use always the same length?
Are the prefixes you use always the same length?Received on Thu Apr 23 2009 - 23:28:02 CEST