> I don't think that MSSQL full text causes any more of a load than Verity > does.
well it causes it on another server at least. plenty of reasons to use full-text in place of verity: - full text searches benefit from sql server's caching, so the more you search the faster they get, verity searches are flat flat flat. - verity never worked properly with unicode, sql server does (at least since 7). - you can combine full-text & "normal" WHERE clauses in the same sql - you do JOINs w/full-text - full-text wins awards (in academic circles) for its searching technology ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
