> > > 2 queries vs 1. i win. > > > > Only if your one query is faster than my two! > > logic dictates that one of your query's is verity based & > slower. verity performance is flat, sql server's benefit > from caching, they (they as in the same ones repeated) > get faster.
Gee, Cash Money! You don't give up easily! Are you sure that shouldn't be "Cache Money"? Seriously, though, I wouldn't be surprised if Verity K2 does provide some internal caching. If your searches are divergent enough (which of course is when you start wanting to provide full-text searches, typically), you're less concerned with caching anyway. Also, I haven't really seen any meaningful benchmarks comparing K2 with MS full-text indexing; K2 is a lot faster than the Verity VDK which CF used to ship with. There are some other things to consider. Verity has a really interesting, and powerful, query language, which allows you to build complex QBE interfaces like those used by Lexis-Nexis or Westlaw (for example, I can say show me all results which have the word "foo", as long as they don't also have the word "bar" in the same sentence. Finally, I'm not sure how the SQL Server full-text indexing affects data updates - if the indexes are dynamically modified, there are some potential performance ramifications. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
