How to reduce PDF generation time »

[somanath]

First Of all Thank You! for providing such a great library for PDF generation with database linkage.

I am generating PDF report using lime report on embedded target board.
For generation 3 page report it will take 20 to 22 seconds,
For generation 1 page report it will take 12 to 14 seconds.

is there any way to reduce time for PDF generation?

Thanks in advance.
Somanath

[Subst]

Hi. It's strange, I've never noticed it.
Generating report in other forms is same? i.e. simple preview?
May be the reason is in the database connection?

[somanath]

Yes! It is due to database.

How can we optimise data retrieving time from database (sqlLite)

is there any option to provide data to lime report in bulk.

in lime report every parameter has separate query so as parameters increase number of queries also increase overall increasing pdf generation time.

there might not be an issue on desktop but in single core embedded target board time taken is much more.

[Arin Alex]

Hi.
You can use Model or CallbackDatasource to transfer data to limereport.

[somanath]

Thanks You! Arin Alex for your response.

will you please elaborate "use Model or CallbackDatasource to transfer data to limereport"

I am new to terms Model or CallbackDatasource so if you explain with example or detailed links will be helpful to me to understand.

[Subst]

You can read the manual first
https://github.com/fralx/LimeReport/blob/master/docs/UserManualEn.pdf
or
https://github.com/fralx/LimeReport/blob/master/docs/UserManualRu.pdf if u speek Russian