Actually, I just spoke with the person who integrated Verity into CFMX. According to him, subsequent(sp) searches in Verity will improve, assuming you are using k2, which would apply to CFMX7, or CFMX 5/6.1 talking to K2.
On 6/23/05, Paul Hastings <[EMAIL PROTECTED]> wrote: > > 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:210337 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
