[Date Prev][Date Next][Thread Prev][Thread Next][Interchange by date
][Interchange by thread
]
[ic] Re: Slow advancedsearch results
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