LimeReport Forum

General Category | Основное => Discussion | Обсуждение => Topic started by: somanath on November 06, 2017, 08:15:55 am

Title: How to reduce PDF generation time
Post by: somanath on November 06, 2017, 08:15:55 am

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

Title: Re: How to reduce PDF generation time
Post by: Subst on November 06, 2017, 09:20:48 am

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?

Title: Re: How to reduce PDF generation time
Post by: somanath on November 06, 2017, 11:24:09 am

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.

Title: Re: How to reduce PDF generation time
Post by: Arin Alex on November 06, 2017, 02:58:40 pm

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

Title: Re: How to reduce PDF generation time
Post by: somanath on November 09, 2017, 12:18:09 pm

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.

Title: Re: How to reduce PDF generation time
Post by: Subst on November 09, 2017, 12:39:31 pm

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