Quoting Barry Treahy, Jr. (suppressed): > Mike Heins wrote: > > >Quoting Barry Treahy, Jr. (suppressed): > > > > > >>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 <suppressed> Opportunity is missed by most people because it is dressed in overalls and looks like work. -- Thomas Edison _______________________________________________ interchange-users mailing list suppressed http://www.icdevgroup.org/mailman/listinfo/interchange-users
Mail converted by mhonarc 2.6.15
This archive provided courtesy of JSW4.NET, Internet Hosting Services for Small Business.