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>



skink wrote:

>
> 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

Original text of this message