Yes, I planned on doing that also. Unfortunately, the issue will still be the same as there are a number of users that will be using the system at all times of the day.
-Lori -----Original Message----- From: Paul Stewart [mailto:[EMAIL PROTECTED] Sent: Friday, March 28, 2008 11:53 AM To: CF-Talk Subject: Re: Verity question 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:302258 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4