Large CF/SQL Reports
|
View:
New views
8 Messages
—
Rating Filter:
Alert me
|
 |
Large CF/SQL Reports
by Torrent Girl
::
Rate this Message:
Hello
I have a question regarding running reports in SQL. I have to run fairly large reports and 99% of the time get a timeout error. I'd try to override the timeout with cfsetting and I also thought about change the setting in cf admin but I am not sure of what is a safe setting. Can anyone tell me the best way to run large reports? They can be made smaller as the requestor needs a lot of info. Any best pratcie tips will be appreciated. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:3130 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.6 |
|
|
RE: Large CF/SQL Reports
by Brad Comer
::
Rate this Message:
Don't use CFML, CFML sucks when it comes to reporting. No matter what anyone
tries to tell you it is not an efficient choice for reports. Try SQL Server reporting services, crystal reports or aspx is even better then CFML in this arena. -----Original Message----- From: Torrent Girl [mailto:torrentgirl@...] Sent: Thursday, September 11, 2008 6:54 PM To: SQL Subject: Large CF/SQL Reports Hello I have a question regarding running reports in SQL. I have to run fairly large reports and 99% of the time get a timeout error. I'd try to override the timeout with cfsetting and I also thought about change the setting in cf admin but I am not sure of what is a safe setting. Can anyone tell me the best way to run large reports? They can be made smaller as the requestor needs a lot of info. Any best pratcie tips will be appreciated. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:3131 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.6 |
|
|
Re: Large CF/SQL Reports
by Torrent Girl
::
Rate this Message:
is SQL reporting free?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:3132 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.6 |
|
|
RE: Large CF/SQL Reports
by Brad Comer
::
Rate this Message:
What version of SQL Server are you running?
-----Original Message----- From: Torrent Girl [mailto:torrentgirl@...] Sent: Thursday, September 11, 2008 9:16 PM To: SQL Subject: Re: Large CF/SQL Reports is SQL reporting free? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:3133 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.6 |
|
|
Re: Large CF/SQL Reports
by Torrent Girl
::
Rate this Message:
>What version of SQL Server are you running?
> You know I don't even know. Enterprise Manager is version 8. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:3134 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.6 |
|
|
Re: Large CF/SQL Reports
by Torrent Girl
::
Rate this Message:
>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:3135 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.6 |
|
|
Re: Large CF/SQL Reports
by Peter Boughton
::
Rate this Message:
> I'd try to override the timeout with cfsetting and I also thought about change the setting in cf admin but I am not sure of what is a safe setting.
Experiment. Set it to five minutes for the report and see what happens. You should have a reasonably low value for cfadmin (30-60 seconds), and use cfsetting for specific long requests. > Can anyone tell me the best way to run large reports? Whether you choose to use CFML, or some part of MS SQL Server, make sure you have correct indexes on all the tables involved. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:3136 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.6 |
|
|
Re: Large CF/SQL Reports
by Mike Chabot
::
Rate this Message:
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 <torrentgirl@...> 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=17837.14401.6 |
| Free embeddable forum powered by Nabble | Forum Help |
