Aug 26, 2010

ColdFusion and CFReport

We use report builder quite a bit and it's not a bad tool for producing reports and being able to absolutely position things is great.

Recently we converted a few reports that we were generating in html then using cfdocument to reports built with report builder.  The speed increase was dramatic from ~15-20 seconds to ~1 second

The server this is runnign on is running ColdFusion 8 standard edition.

In CFADMIN there is this setting:


 
The maximum number of ColdFusion reports that can be processed concurrently.


There is very little information on this but I presume that only 1 report can run at a time.  Am I understanding this correctly?  If 50 people hit it at the same time are they queued?  We haven't had any issues yet but I want to look at our options and find out why/if we need to upgrade this server to Enterprise.
Posted by Paul Kukiel at 12:17 AM

6 comments:

  1. I'm a fan of CFREPORT to and really wish they would have kept improving on it. I don't have an answer for you sorry but in this doc http://www.adobe.com/products/coldfusion/whitepapers/pdf/91025512_cf9_lockdownguide_wp_ue.pdf it reads to keep it set to '1' unless you are using CFREPORT heavily. Could you test it by simulating multiple hits at once and see how it holds up being set to '1'?

    Unfortunately it feels like CFREPORT was given up on, and like with most things that are ignored, the documentation suffers along with it. A real bummer.
    ReplyDelete
  2. @Steve when I was at Max in 2008 I was told the CFReport was still begin worked on and that with CF10 there will be a new Report Builder and it will most likely be like CFBuilder and Flash Builder and run from eclipse. Now they didn't say 100% that it would happen but that with CF10 there should be such an update.
    ReplyDelete
  3. I think it is limited to 1 for standard edition.
    ReplyDelete
  4. @Henry. Yes It is. Which is why I wanted to confirm its from cfreport requests and what happens to the requests if multiple users hit the report at the same time and if this settign will have a significant impact if we were to move to Enterprise on this server.
    ReplyDelete
  5. Please explain insert pictures dynamically in cfreport builder 8. we have to insert image from common image repository.

    kindly mail me to maagesh@gmail.com

    Thanks
    ReplyDelete
  6. @Anonymous Reference the picture in the query you pass to report builder.
    ReplyDelete

Subscribe to: Post Comments (Atom)