[ic] HTdig or Googling a local IC Site for better search results on numerous columns

Mike Heins mike at perusion.com
Wed Jul 28 22:21:08 EDT 2004

Quoting Barry Treahy, Jr. (Treahy at mmaz.com):
> Mike Heins wrote:
> >Quoting Barry Treahy, Jr. (Treahy at mmaz.com):
> > 
> >
> >>Has anyone assembled an integrated search or advanced search feature 
> >>into IC that would better handle keyword searches across a large number 
> >>of columns in a MySQL database?  At present, the method I'm doing are 
> >>searches against INDEX columns on some of the key fields and then 
> >>attempting to reduce that, but the flexibility sucks and the performance 
> >>is even worse;  I'm 4.8.6. 
> >>   
> >>
> >
> >Why aren't you using Interchange's text search? It does this type of thing
> >pretty well, certainly better than what you can construct with a SQL query.
> >
> >All that is required is that you export to a text file.
> > 
> >
> Ok, I suspect that I'm already doing some of this, please correct me if 
> I'm wrong.

There is nothing "sql query" about the search. I am talking about:

	<form action="[process href=search]">
	<input type=text name=mv_searchtype value=text>
	<input type=text name=mv_searchspec>
	<input type=submit>

That is all it takes to full-text search your products.txt files.

> I get nothing, forget that I need to compound the search query and would 
> also like to 'limit' it so a reasonable max and the match limit appears 
> to be ignored.
> >If your database is so huge that you are going to externally index you
> >should probably try to leverage swish-e (which has an IC module) or
> >mNoGoSearch or something.
> > 
> >
> Don't know how huge is too big, but there is over 20k SKU's and the are 
> 52 columns in my products table of which about 40 could be searched on, 
> and of those 40, the meaning of their value differs based on the product 
> category...

For 20,000 records this should be the next thing to instantaneous on
any type of modern system.

Mike Heins
Perusion -- Expert Interchange Consulting    http://www.perusion.com/
phone +1.765.647.1295  tollfree 800-949-1889 <mike at perusion.com>

Opportunity is missed by most people because it is dressed in
overalls and looks like work. -- Thomas Edison

More information about the interchange-users mailing list