[ic] Re: Slow advancedsearch results

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


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.

> 
> 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. 
> _______________________________________________
> interchange-users mailing list
> interchange-users@icdevgroup.org
> http://www.icdevgroup.org/mailman/listinfo/interchange-users
> 

-- 

Christopher F. Miller, Publisher                               cfm@maine.com
MaineStreet Communications, Inc           208 Portland Road, Gray, ME  04039
1.207.657.5078                                         http://www.maine.com/
Content/site management, online commerce, internet integration, Debian linux