Bad performance when running report for 6000 records

Stimulsoft Reports.PHP discussion
Super Bread
Posts: 36
Joined: Mon Aug 08, 2011 12:51 am

Bad performance when running report for 6000 records

Post by Super Bread »

Hello,

I'm running the report in designer which spent 38 seconds for ~6300 records in 286 pages. That report includes 18 fields. It also spent 57 seconds if running through PHP program. This performance is not been acceptable. Is any solution or some setting provided?

Thanks.
Ivan
Posts: 960
Joined: Thu Aug 10, 2006 1:37 am

Bad performance when running report for 6000 records

Post by Ivan »

Hello,

Can you please send us a sample report template with data, which reproduce the issue?

Thank you.
Super Bread
Posts: 36
Joined: Mon Aug 08, 2011 12:51 am

Bad performance when running report for 6000 records

Post by Super Bread »

Sample report is attached, please check.
Attachments
1744.BadClientRpt.mrt
(38.91 KiB) Downloaded 299 times
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Bad performance when running report for 6000 records

Post by Alex K. »

Hello,

Can you please send us a test data for your report.

Thank you.
Super Bread
Posts: 36
Joined: Mon Aug 08, 2011 12:51 am

Bad performance when running report for 6000 records

Post by Super Bread »

How can I send you the testing data which data are retrieved from mysql? And the testing data has some private data, how can I attach the file to you by private email? I don't want to post it in public area. Thanks.
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Bad performance when running report for 6000 records

Post by HighAley »

Hello.
Super wrote:How can I send you the testing data which data are retrieved from mysql? And the testing data has some private data, how can I attach the file to you by private email? I don't want to post it in public area. Thanks.
Please, send it to support@stimulsoft.com with link on this topic.

Thank you.
Super Bread
Posts: 36
Joined: Mon Aug 08, 2011 12:51 am

Bad performance when running report for 6000 records

Post by Super Bread »

Do I send the sql insert statement to you for the testing data?
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Bad performance when running report for 6000 records

Post by HighAley »

Hello.
Super wrote:Do I send the sql insert statement to you for the testing data?
Yes, send us a data to get the 6000 rows report.

Thank you.
Super Bread
Posts: 36
Joined: Mon Aug 08, 2011 12:51 am

Bad performance when running report for 6000 records

Post by Super Bread »

The sample report and testing data are sent to your support email, please check. Thanks.
Andrew
Posts: 4108
Joined: Fri Jun 09, 2006 3:58 am

Bad performance when running report for 6000 records

Post by Andrew »

Hello,

Thank you. We will reply you from support@stimulsoft.com

Thank you.
Post Reply