Protoculture wrote: > Now using MSSQL, do you think there could be a performance > improvement by switching this search to the database?
if you mean using sql server's full-text indexing, "yes". while k2 has certainly been an improvement, verity searches performances are flat compared to db ones (search the same phrase 10x, verity more or less takes the same amount of time, every time while the db based one will get faster). joining the verity results back to the database isn't nearly as elegant as sql server's. and believe it or not, ms's search wins academic awards pretty consistently (see trec.nist.gov). but speed isn't the only thing to consider. the purpose of your search and how each technology handles that should also be looked into. you should probably post this question on the sql server list (www.sswug.org) or sql server newsgroup (http://www.microsoft.com/technet/community/newsgroups/server/sql.mspx at the bottom of the page) and maybe hillary cotter will answer (he's a guru when it comes to searching). sql server 2005 is supposedly better at this than sql server 2000. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210328 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
