Re: Question about search performance
Re: Question about search performance
- Subject: Re: Question about search performance
- From: Guido Neitzer <email@hidden>
- Date: Tue, 16 Sep 2008 13:26:45 -0600
- Thread-topic: Question about search performance
On 16.09.08 13:22, "Chuck Hill" <email@hidden> wrote:
>> Why? If there is a case insensitive index on that column it should be able
>> to use it as it is just a begins with search.
>
> I don't think the optimizer will match the collation to the UPPER
> functions in the query. So this will table scan. I did not see why a
> table scan with a trailing wildcard would be more than a minute slower
> than this.
File system caching? If the queries are executed one after the other.
Joshua, how did you make the testing?
>> As it will use the index. How is FrontBase than handling case
>> sensitive
>> searches (if they are needed)?
>
> Unless there is a need for case sensitive ones, I just make the column
> collate case insensitively. Of course, you still want an index on
> that column.
Right, I remember. It's something set on the column, not on the index in
FrontBase.
cug
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden