Hi all,
I have an application that exports a grid to PDF. I handle several events to make changes to the layotu of the grid so that it looks more like a report in the PDF document.
We've been testing the speed of generating the report and have noticed that the difference in exporting 10, 20 or 30 thousand rows does not differ (only by a few seconds - taking over 5 minutes in total). We're filtering the rows down from 30,000 to test - expecting that it would be quicker. There is also no difference between 50 and thousands of rows either...
Does anyone know what factors affect the performance of the PDF export?
Is it the number of rows (regardless of any filters), the number of columns, the number of pages it produces etc.?
We have found that collapsing any groups in the grid does speed the report generation greatly, however.
Any help will be greatly appreciated.
Cheers,
Richard
Hi Richard,
Are you saying that it takes 5 minutes to export 50 rows? I can understand thousands of rows taking that much time, although it still seems pretty high and I've never seen it take that long. It also depends on the speed and RAM on the machine.
But if you have a sample which demonstrates 50 rows taking 5 minutes to export, I'd love to see it, because there's clearly something very wrong there.
Have you tried running it through a performance profiler?
What version are you using?
Sorry mike i didn't respond to your other questions:
No, I haven't tried running it through a performance profiler, and we're using 2010.3 with the latest hotfix (2015).
Hi Mike,
Thanks for the swift reply!
Yes, but there are about 40,000 rows in the grid. Filters are applied to reduce the rows to 50 and there appears to be no difference between the time take to output all 40,000 rows and the 50 rows that remain after filtering, to a document.
The main thing is we see no difference in the time to output the grid when rows are filtered out. I understand they're still there (and simply marked as filtered). But reducing the number of columns in the grid from about 70 down to about 10 halves the time to about 2 or 3 minutes. Another thing that appears to greatly reduce the time is grouping the data and collapsing all the groups.
Does this sound like the document exporter is unnecessarily processing the 30-odd thousand filtered-out rows too?