you could schedule just the one index every 24 hrs in the quite hours instead of after each new record addition
Stone, Lori wrote: > 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:302257 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
