> From: John Inferrera [mailto:[EMAIL PROTECTED] > Does any one have a suggestion of how to avoid this? I > thought "How many users will hit this at the exact time the > package runs..." Well how about over a hundred a day! Should > I use SQL or CF (CF MX 6.1 Ent on W2K3) to lock this till the > package runs? I
John, One thing I have done in the past is to set a flag in the DB when the task starts which your application can check before running the page that would error the application out. When the package is done running, change the flag back so the application can present the user with the page again.... We use to use this when updating our "order" database at 3 AM. If you tried to view your past orders you got a message "System currently updating records, please try back in 5 minutes". I am sure some others will chime in with alternate approaches. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192172 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
