[ic] Re: Slow advancedsearch results

interchange-users@icdevgroup.org interchange-users@icdevgroup.org
Tue Oct 15 10:23:00 2002


cfm@maine.com writes: 

> On Tue, Oct 15, 2002 at 04:00:30PM +0200, racke@linuxia.de wrote:
>> 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%'; 
> 
> My understanding is that mySQL **can** use an index where the
> LIKE string is at start of field, like 'bed%' but **cannot** use
> it where it is not, as in '%bed%'.  Description like 'bed%' is
> not going to help with 'king beds, queen beds' or maybe I misunderstand
> what mv_like_spec is supposed to do.

I dunno know if mv_like_spec=%bed will work, but you can cheat
in mv_click, e.g. mv_like_spec=%[cgi mv_like_spec]. 

It's true you cannot use the index, but saving the overhead of
passing and parsing the whole table by Interchange will help
on larger databases. 

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.