[ic] Re: Slow advancedsearch results

[interchange-users@icdevgroup.org (interchange-users@icdevgroup.org)]

cfm@maine.com writes: 

> On Mon, Oct 14, 2002 at 09:46:12AM -0700, Barry Treahy, Jr. wrote:
>> racke@linuxia.de wrote: 
>> 
>> >Barry Treahy, Jr. writes:
>> >
>> >>Initially, I had yanked this from my site as the results were truly 
>> >>painful with dbm.  Since we've running running on mySQL for the past 
>> >>weeks, I figured that I would back track some of the issues that I 
>> >>could not address, or figure out, prior to the launch and sadly, even 
>> >>with SQL my wildcard searches are still painfully slow.  
>> >>It appears that that is killing me is when the op code for the column 
>> >>is a rm rather than an eq.  Is there another way to state a search 
>> >>that basically examines the column for the content that may not be an 
>> >>exact match which is faster?
>> >
>> >
>> >For SQL databases mv_like_field and mv_like_spec are useful to speed
>> >up searches. 
>> 
> 
> "like" is not going to be fast.  See the mysql docs for why.  There are
> ways to build indices of text fields (assuming that is what you are
> searching).

It is definitely faster if you have a substantial number of records.
Without qualification IC needs to get all records of the database
and examine them instead applying that to a subset of the database
if you use like. Of cause op=eq on an SQL
indexed field would be better. 

Bye
    Racke 

 

-- 
Prolific Interchange Consulting (Excellent German Quality !).
Take a look at Materialboerse (http://www.materialboerse.de/), WITT
(http://www.witt-weiden.de/), Boxmover (http://shop.boxmover.ch/) or
Passionshop (http://www.passionshop.com/racke). Need a shop ? Contact us.