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

Mike Heins mike at perusion.com
Wed Jul 28 15:12:34 EDT 2004

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.

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 <mike at perusion.com>

Research is what I'm doing when I don't know what I'm doing.
-- Wernher Von Braun

More information about the interchange-users mailing list