We have an app that is using verity to search docs and db. What is the best process for speed when thinking about updating the index and doing the cfsearch. There are thousands of records and will be a pretty substantial amount of traffic. So far what I have read is the do a cflock around all cfsearch tags and an exclusive lock around the indexing (full and partial). The index will be updated when records/docs have been updated. Does anyone have any experience with this? Is there a better way of doing this? I am just worried about the cflock slowing everything down if there are a lot of people accessing it at the same time.
Thanks! -Lori ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302253 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
