> Gee, Cash Money! You don't give up easily! Are you sure that shouldn't be > "Cache Money"?
ahem. neither does 'belt-em first' dave washington watts > Seriously, though, I wouldn't be surprised if Verity K2 does provide some no idea. i need thai text indexing & verity's never thrilled me so i've never taken the next step. i have benchmarked verity 97(?) & sql server 7 though. > when you start wanting to provide full-text searches, typically), you're > less concerned with caching anyway. Also, I haven't really seen any if you're banging thru 100k or millions of rows you'll take whatever you can get. > There are some other things to consider. Verity has a really interesting, > and powerful, query language, which allows you to build complex QBE so does sql server though maybe not as sophisticated as verity--i can ask the full text guru (he's working on a test bed of 10-20 million rows, i think he's ported the BoL) just to be sure. > 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 can do something similar w/sql server AND do a join on another table to boot. > Server full-text indexing affects data updates - if the indexes are > dynamically modified, there are some potential performance ramifications. if you drop a TIMESTAMP column on your indexed table it cuts this down considerably. sql 2k is way better at this than sql 7. though i'd plan for full text indexing not wake up one morning & think hey it might be fun to full text that 50 million row table w/3 TEXT columns ;-) ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com 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
