|
Regarding large datasets, is there any suggestion to speed up report generation process ?
Using RW::Datasource::DBI here is the elapsed times for a few datasets:
(Only a single column is selected)
SELECT acolumn FROM atable limit 50 : Elapsed 8.161 secs.
SELECT acolumn FROM atable limit 100 : Elapsed 11.166 secs.
SELECT acolumn FROM atable limit 500 : Elapsed 42.1 secs.
SELECT acolumn FROM atable limit 1000 : Elapsed 83.87 secs.
SELECT acolumn FROM atable limit 2000 : Elapsed 197.063 secs.
I tried to join fields to a single column and used a fixed-font to reduce number of cells to be formatted etc. But it didn't helped very much.
PDF-ReportWriter is very useful and flexible actually. The only problem I think is the performance issue regarding large datasets or reports of few pages with, for example, 10 columns.
Thanks in advance...
|