logo

Warning: The forum is now for consultation only. Please use GitHub Discussions to post any questions or comments.


Welcome Guest ! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
Melesew  
#1 Posted : Thursday, May 19, 2022 6:00:23 AM(UTC)
Melesew

Rank: Newbie

Groups: Registered
Joined: 3/11/2021(UTC)
Posts: 0
Ethiopia
Location: Addis Ababa

I have tried both versions, Seal Report 6.1 and 6.5 with the same hardware specifications. But both are extremely slow compared to Seal 5.0. And the problem I notice is when a report has more than one model. A report having 4 models is four times slower. There seems no parallel execution on the models.

Can anyone help me to make reports faster in execution in Seal Report 6.1
DharanGokul  
#2 Posted : Tuesday, May 24, 2022 11:21:49 AM(UTC)
DharanGokul

Rank: Newbie

Groups: Registered
Joined: 4/7/2022(UTC)
Posts: 4
Man
India
Location: Erode

Thanks: 1 times
check the query running time. Query takes more time to execute
Melesew  
#3 Posted : Wednesday, May 25, 2022 5:55:45 AM(UTC)
Melesew

Rank: Newbie

Groups: Registered
Joined: 3/11/2021(UTC)
Posts: 0
Ethiopia
Location: Addis Ababa

Thank your reply DharanGokul.

My Query(View in the database) takes 30 seconds to generate the result. And I have used my View as a source table and generated 3 models all having the same restrictions and prepared a report.

This report generates results in 30 to 35 seconds in seal Report 5.1 (pretty fast). But the latest version (seal report 6.5) it is taking about 135 seconds (3 times slower).
DharanGokul  
#4 Posted : Monday, May 30, 2022 2:47:43 PM(UTC)
DharanGokul

Rank: Newbie

Groups: Registered
Joined: 4/7/2022(UTC)
Posts: 4
Man
India
Location: Erode

Thanks: 1 times
I am also facing these issues.
epf  
#5 Posted : Tuesday, May 31, 2022 6:00:12 AM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 1,209
Switzerland

Thanks: 14 times
Was thanked: 205 time(s) in 198 post(s)
perhaps it is related to the database driver, what database are you using ?
DharanGokul  
#6 Posted : Tuesday, May 31, 2022 12:22:01 PM(UTC)
DharanGokul

Rank: Newbie

Groups: Registered
Joined: 4/7/2022(UTC)
Posts: 4
Man
India
Location: Erode

Thanks: 1 times
I am using mssql
epf  
#7 Posted : Wednesday, June 1, 2022 7:40:17 AM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 1,209
Switzerland

Thanks: 14 times
Was thanked: 205 time(s) in 198 post(s)
You can check the report information of the reports:
how long takes each model to be built.
check the log file to see what is taking long time and you can compare with the previous version.
e.g. for Northhwind:

09:39:20 Starting execution of 'Search - Orders' (No security context)...
09:39:20 Starting to build models...
09:39:20 Build models of Execution set 1...
09:39:20 Model 'orders': Loading result table...
09:39:20 Model 'orders': Executing main query...
09:39:20 Model 'orders': Building pages...
09:39:20 Model 'orders': Building tables...
09:39:20 Model 'orders': Building totals...
09:39:20 Rendering report...

so you can see exactly why the reports takes time.

Users browsing this topic
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.