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. 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. -- Mike Heins Perusion -- Expert Interchange Consulting http://www.perusion.com/ phone +1.765.647.1295 tollfree 800-949-1889 <suppressed> Research is what I'm doing when I don't know what I'm doing. -- Wernher Von Braun _______________________________________________ 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.