[ic] Re: Slow advancedsearch results

interchange-users@icdevgroup.org interchange-users@icdevgroup.org
Mon Oct 14 14:35:01 2002


On Mon, Oct 14, 2002 at 09:46:12AM -0700, Barry Treahy, Jr. wrote:
> 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.
> 

"like" is not going to be fast.  See the mysql docs for why.  There are
ways to build indices of text fields (assuming that is what you are
searching).

Is there still a glimpse option in newer ic?  That might help

> 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...
> 
> Barry
> 
> -- 
> 
> Barry Treahy, Jr  *  Midwest Microwave  *  Vice President & CIO 
> 
> E-mail: Treahy@mmaz.com * Phone: 480/314-1320 * FAX: 480/661-7028
> 
> 
> 
> _______________________________________________
> 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