[ic] HTdig or Googling a local IC Site for better search results
on numerous columns
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>
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
For 20,000 records this should be the next thing to instantaneous on
any type of modern system.
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