> no caching. can't join back to the indexed table. can't > combine with other > WHERE clause stuff. sql server text indexing beats the pants > & socks off of verity.
We use both in different situations Verity has the text branching, so if you enter a word, it'll include plural, "ing" and such like SQL Server can be cached, but you'll end up eating the CF cache memory if you have loads of sites and quite a few searches (as our servers do) It's horses for courses, but there are uses for both... Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk www.aspevents.net An ISO9001 registered company. ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ********************************************************************** ______________________________________________________________________ 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
