Posted on 2006-10-06 21:05:30-07 by kardi
Performance
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...
Direct Responses: Write a response
Perl Weekly newsletter
A free weekly newsletter for people who are busy to read all the blogs. click here to check it out.