Very Slow performance when rendering report

[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!

[HighAley]

Hello.

Sorry, but there is no video in the attachment.
Could you specify how many records your query returns?

Thank you.

[vladimir_forlogic]

Vídeo sended! Sorry!

The query will return about 1300 records

[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.

[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.

[Alex K.]

Hello,

We couldn't reproduce this bug.
Please send us a sample project which reproduce the issue for analysis.

Thank you.

[vladimir_forlogic]

Hello,

The project is very big.

Can I send only the report?

I posted it in attachments.

Thank you.

[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.

[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!

[Alex K.]

Hello,

Ok.
Let us know if you need any additional help.

Thank you.