I'm assuming it's the actual PDF generation thats causing the issue? If you run the queries on their own they spew out the data in a timely fashion?
Out of interest, have you tried to see if flashpaper generation is quicker? Andy On 19/07/06, Neil Middleton <[EMAIL PROTECTED]> wrote: > Yeah, I thought of trying both of these. The trouble I'm having is that > generating a single PDF page with the "high-performance" reporting (all > queries done outside the report) is taking longer than if I were to crack > out the crayons and draw it out myself. > > On 7/19/06, Andy Allan <[EMAIL PROTECTED]> wrote: > > > > Depending on your requirements and environment, one possible way to > > deal with this is: > > > > 1) Dedicated instance just for reporting > > 2) Use asynch gateway to hand off the report generation and then > > forget about it. > > > > Of course, you need Ent for this. > > > > Andy > > > > On 19/07/06, Neil Middleton <[EMAIL PROTECTED]> wrote: > > > Does anyone have any experience of bad performance when generating PDF's > > in > > > CF7 with CFReport? > > > > > > Currently I'm trying to put together a process to generate around 100 > > > dynamically populated PDF's at a time, but the performance is turning > > out to > > > be real bad (~1 min per PDF, not including getting the data.) > > > > > > Does anyone know any ways of speeding things up a little? > > > > > > -- > > > Neil Middleton > > > > > > Visit feed-squirrel.com > > > > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:247028 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4