> Verity should do a better job if your not already using it.
no, sql server full text indexing beats the pants & socks off
of verity. first off , it could be on another box altogether, cf
just hands off the query to sql server box instead of having to
help do the heavy lifting. secondly, since its part of sql server,
you get to take advantage of its caching. ask for the same thing
over & over again in verity takes exactly the same time each &
every time. with sql server's full text indexing you will see the
query times dwindle away as its caching kicks in.....and sql
server full text indexing handles "funny" languages like thai. etc.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
