Well, I am now caching the queries between requests, so I have effectively ruled that out of the equation.
However, I did notice the original report I have been given contained TIF's. Replacing these with JPG's made the generation time drop to less than a second. :-) Thanks for the help anyway. N On 7/19/06, Andy Allan < [EMAIL PROTECTED]> wrote: > > 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:247029 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
