Your slow reports have almost nothing to do with running ColdFusion. It is just a sign that your report is taking too long to process, which could be for any number of reasons. The most common reason is slow unoptimized queries. I have taken 10 hour reports down to 10 second reports by optimizing the SQL. The next most common problem is running thousands of queries in a page because a query tag is inside of a loop. It is important to understand the reason the report is taking so long so you know what needs to be sped up.
If you have a page that takes predictably longer to run than other pages, you can certainly increase the timeout of that page to whatever you want. You can set the timeout to 30 hours if you really want to, although keep in mind that this will tie up one of the precious processing threads for that long unless you configure the report to run asynchronously. If someone keeps pressing the browser reload button on that long report your server won't have any processing threads left over for other requests. You do occasionally get some reports that take a while no matter how excellent the SQL is. In this case there is a lot you can do with caching, changing the data model, running the reports on a separate server, scheduling the reports to run overnight, setting up a dedicated reporting database, using a different reporting technology, etc. I would recommend staying away from SQL Server 2000 reporting services. It is old technology at this point that has been eclipsed by the newer versions. Good luck, Mike Chabot On Thu, Sep 11, 2008 at 11:41 PM, Torrent Girl <[EMAIL PROTECTED]> wrote: >>What version of SQL Server are you running? > > I found it. It is 2000. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:3137 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
