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