Rank: Newbie
Groups: Registered
Joined: 3/17/2017(UTC) Posts: 6   Location: India Thanks: 4 times
Was thanked: 1 time(s) in 1 post(s)
|
I had a query regarding the minimum system requirements for running seal web server application.
And related to the performance of web application as we have a report which loads up to 10 million records and there are 1000 users for the same report. So i wanted to know is seal report a feasible solution for providing that report.
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209  Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
|
Good question, I tested SR with a report having 100'000 records and it works fine as the pagination is done on the server...
Then we do not have experience for 10 million records and 1000 users (at the same time ?), this should be tested and probably tuned.
Any other experiences or feedback on using SR in such conditions ?
|
 1 user thanked epf for this useful post.
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 3/17/2017(UTC) Posts: 6 Location: India Thanks: 4 times
Was thanked: 1 time(s) in 1 post(s)
|
(at the same time ?) Yes
The system gets crashed it consumes lot of memory in 30 million records for a single report single user.
If the application uses database side pagination it would make application more robust and less memory consuming for large number of reports per large number of users.
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209 Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
|
The engine could be enhanced (with database pagination for example) but I think it is a bad design to let the user run a report having 30 millions of records...
You could at least force some restrictions to limit the result set (flag Required in the restriction properties).
|
1 user thanked epf for this useful post.
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 3/17/2017(UTC) Posts: 6 Location: India Thanks: 4 times
Was thanked: 1 time(s) in 1 post(s)
|
Yes we have used restrictions but suppose for a report such as an Audit report the data can be ranging from years may be decade then the records will be in huge amount. And if multiple users are accessing the report from different sessions then in that case the application will be able to handle the situation.
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209 Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
|
|
|
|
|
|
|
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.
