[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.
[snip]
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>
</form>
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