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

Notification

Icon
Error

Options
Go to last post Go to first unread
gaurav11  
#1 Posted : Saturday, November 11, 2017 6:57:18 AM(UTC)
gaurav11

Rank: Newbie

Groups: Registered
Joined: 3/17/2017(UTC)
Posts: 6
Man
India
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.
epf  
#2 Posted : Monday, November 13, 2017 8:02:16 AM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 391
Switzerland

Thanks: 6 times
Was thanked: 53 time(s) in 52 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 ?

thanks 1 user thanked epf for this useful post.
gaurav11 on 11/13/2017(UTC)
gaurav11  
#3 Posted : Monday, November 13, 2017 12:35:07 PM(UTC)
gaurav11

Rank: Newbie

Groups: Registered
Joined: 3/17/2017(UTC)
Posts: 6
Man
India
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.
epf  
#4 Posted : Tuesday, November 14, 2017 10:53:00 AM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 391
Switzerland

Thanks: 6 times
Was thanked: 53 time(s) in 52 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).
thanks 1 user thanked epf for this useful post.
gaurav11 on 11/14/2017(UTC)
gaurav11  
#5 Posted : Tuesday, November 14, 2017 12:47:58 PM(UTC)
gaurav11

Rank: Newbie

Groups: Registered
Joined: 3/17/2017(UTC)
Posts: 6
Man
India
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.
epf  
#6 Posted : Tuesday, November 14, 2017 5:40:46 PM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 391
Switzerland

Thanks: 6 times
Was thanked: 53 time(s) in 52 post(s)
another way to limit the result set is described here:
http://forum.sealreport.org/default.aspx?g=posts&t=7#post20
Users browsing this topic
Guest (2)
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.

Powered by YAF 2.0.0 | YAF © 2003-2017, Yet Another Forum.NET
This page was generated in 0.080 seconds.