I'm in need of some full text searching of one or two fields within my database. I'm currently using Oracle 8.0.5 and I can't find anything about full text searching... I can't use Verity because I'm trying to search within database columns, not files.
The goal is to optimize the search for products in our database either by the name of the product or its extended description. Right now, I use a simple LIKE sql expression (with ANDs for multiple keywords) that can take quite a bit too long. There's something interesting that phpBB does which is to create a psuedo index of keywords and their related topics: topicid keyword 1 foo 2 foo 1 bar 3 bar 4 fee 4 fi 4 fo Then the search looks in that table on which the keyword column can be indexed and no LIKE is needed, though for substring searches you're back to using LIKE again. Any other ideas? Or comments on the psuedo index idea? Tony Schreiber, Senior Partner Man and Machine, Limited mailto:[EMAIL PROTECTED] http://www.technocraft.com http://www.simplemessageboard.com ___Free Forum Software for Cold Fusion http://www.is300.net ___________The Enthusiast's Home of the Lexus IS300 http://www.digitacamera.com ______________DigitA Camera Scripts and Tips http://www.linklabexchange.com _____________Miata Link ECU Data Exchange ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
