Can't you set a query timeout ? -----Original Message----- From: Ian Skinner [mailto:h...@ilsweb.com] Sent: Thursday, April 23, 2009 11:14 AM To: cf-community Subject: Re: YIKES! I must let internet users write SQL queries for our database!
Ian Skinner wrote: > Did I get your attention? Luckily these are read-only queries, but still! I forgot to mention an important consideration is to somehow control and mitigate query requests so that users don't tie up the database with a task taking hours and hours to process. It is already a batch processing system, where the users do not get the response immediately, but rather it is submitted to a que and then the user receives an e-mail with a ftp link to the resulting output files when their request is completed. But, more and more frequently a request is to large and|or complex and it ties up the que so that nothing can be done until such a time as a DBA can get in there and kill the process that is jamming up the system. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-community/message.cfm/messageid:295807 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5
