[ic] Re: Slow advancedsearch results

interchange-users@icdevgroup.org interchange-users@icdevgroup.org
Sat Oct 12 11:53:01 2002


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. 

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.