> Correct about MSSQL, in either case, both solutions require that the > database be indexed with some degree of frequency, the amount of that > freqency is dependent upon your need for accuracy in real time.
full-text indexing engine can "know" whats been changed if your indexed rows are TIMESTAMPed, the actual data thats re-indexed is usually therefore much smaller than the whole. you can do the same in verity but its more load on servers as well as needing an extra mechanism to be coded. full-text can be setup as a "fire & forget" mode. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
