Page 1 of 1
Very Slow performance when rendering report
Posted: Mon Feb 22, 2016 7:44 pm
by vladimir_forlogic
Hi,
I'm having a very slow performance when rendering a web report. The problem it's with the combo box control.
In attachments I post one video to demonstrate.
Other relevant details:
Stimulsoft version: 2015.1.14.0
Using StiWebViewer: yes
SQL Running with problem:
Code: Select all
select distinct
0 as id,
'[Todos]' as name
union
select distinct
s.id,
s.name
from suppliers s
where s.removed=0 and s.is_manufacturer = 1
order by name
Some idea?
Thanks!
Re: Very Slow performance when rendering report
Posted: Tue Feb 23, 2016 8:02 am
by HighAley
Hello.
Sorry, but there is no video in the attachment.
Could you specify how many records your query returns?
Thank you.
Re: Very Slow performance when rendering report
Posted: Tue Feb 23, 2016 6:14 pm
by vladimir_forlogic
Vídeo sended! Sorry!
The query will return about 1300 records
Re: Very Slow performance when rendering report
Posted: Wed Feb 24, 2016 11:07 am
by HighAley
Hello.
Could you try our latest builds? There was some performance improvements.
Also, please, try to use StiMobileDesigner. It is based on HTML5 and is available on mobile devices.
Thank you.
Re: Very Slow performance when rendering report
Posted: Mon Feb 29, 2016 8:31 pm
by vladimir_forlogic
Thanks for your message.
I got the same result. I've reduced the total number of records from 900 to 200 and updated to last build but, don't worked.
More suggestions?
Thank you.
Re: Very Slow performance when rendering report
Posted: Tue Mar 01, 2016 7:10 am
by Alex K.
Hello,
We couldn't reproduce this bug.
Please send us a sample project which reproduce the issue for analysis.
Thank you.
Re: Very Slow performance when rendering report
Posted: Tue Mar 01, 2016 11:08 am
by vladimir_forlogic
Hello,
The project is very big.
Can I send only the report?
I posted it in attachments.
Thank you.
Re: Very Slow performance when rendering report
Posted: Wed Mar 02, 2016 12:57 pm
by HighAley
Hello.
Sorry, but there is no data for your report.
We need to reproduce the issue to help you.
Please, send us a sample project that reproduces the issue.
Thank you.
Re: Very Slow performance when rendering report
Posted: Wed Mar 02, 2016 1:09 pm
by vladimir_forlogic
Thanks for you help!
We can close this issue.
During tests I and my team found that the problem was with the web server of my client that are using an ip routing service: "no-ip.net".
When refactored the report and accessed the web application using the native ip address without ip routing, the problem was fixed.
Additionally, we are planning to change the structure of the web application to manage reports more efficently.
Thanks a lot!
Re: Very Slow performance when rendering report
Posted: Thu Mar 03, 2016 7:09 am
by Alex K.
Hello,
Ok.
Let us know if you need any additional help.
Thank you.