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:295795 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5