Re: general design issue
From: Bob Badour <bbadour_at_pei.sympatico.ca>
Date: Thu, 23 Apr 2009 18:28:02 -0300
Message-ID: <49f0dd64$0$5455$9a566e8b_at_news.aliant.net>
>
> 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...
Date: Thu, 23 Apr 2009 18:28:02 -0300
Message-ID: <49f0dd64$0$5455$9a566e8b_at_news.aliant.net>
skink wrote:
>>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?