[ic] Re: Slow advancedsearch results

interchange-users@icdevgroup.org interchange-users@icdevgroup.org
Tue Oct 15 10:02:01 2002


Barry Treahy, Jr. writes: 

> 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.
> 
> It is probably just a bad case of the 'stupids' effecting me because I 
> cannot find any details on these at the ICDEV site as both are returning 
> no hits on the site or the user list archives...

mv_like_field=description
mv_like_spec=bed 

SQL => select * from products where description like 'bed%'; 

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.