Rank: Newbie
Groups: Registered
Joined: 3/11/2021(UTC) Posts: 0  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
|
|
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 4/7/2022(UTC) Posts: 4   Location: Erode Thanks: 1 times
|
check the query running time. Query takes more time to execute
|
|
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 3/11/2021(UTC) Posts: 0 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).
|
|
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 4/7/2022(UTC) Posts: 4 Location: Erode Thanks: 1 times
|
I am also facing these issues.
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209  Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
|
perhaps it is related to the database driver, what database are you using ?
|
|
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 4/7/2022(UTC) Posts: 4 Location: Erode Thanks: 1 times
|
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209 Thanks: 14 times
Was thanked: 206 time(s) in 199 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.
|
|
|
|
|
|
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.
