>From the research I've done it looks like the only difference is that now when you back up the db, the full text search catalogs get backed up with it.
Also seems like there is an option (perhaps the default) where if data changes in the full text columns, it automatically reindexes them. It all depends on what you need the full text search capability for, but for my purposes, I did a lot of research and ended up using Lucene. It's just awesome, and I was able to write a cfc to interface with it. What I needed to do was to search a single text document for 100k different keywords. Lucene does this in less then a minute, while sql and verity would've taken forever. Russ > -----Original Message----- > From: Dennis Powers [mailto:[EMAIL PROTECTED] > Sent: Wednesday, December 13, 2006 4:39 PM > To: CF-Talk > Subject: MS SQL 2005 vs. MS SQL 2000 freetext search differences > > I was wondering if anyone has had any experience with the MS SQL2005 > search > capabilities and can offer any insights into any improvements that may > have > been made. We are looking at upgrading to MSSQL2005 from MS SQL2000 and a > couple of the sites use the freetext search capabilities. Have there been > any improvements in the MSSQL search capabilities? > > The one site in particular is a 1.5 to 2.5 million page views/month and > although verity returns better results was found to be much to processor > intensive so we switch to MSSQL freetext searching. I am always looking > to > obtain better search results. > > > Best Regards, > > Dennis Powers > UXB Internet - A website design and Hosting Company > 690 Wolcott Road > P.O. Box 6029 > Wolcott, CT 06716 > Tel: (203)879-2844 > http://www.uxbinternet.com/ > http://www.uxb.net/ > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264001 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
