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

Notification

Icon
Error

Options
Go to last post Go to first unread
Sujeet Kumar T  
#1 Posted : Friday, October 9, 2020 6:15:18 AM(UTC)
Sujeet Kumar T

Rank: Newbie

Groups: Registered
Joined: 8/12/2019(UTC)
Posts: 6
India
Location: Hyderabad

Thanks: 2 times
Hi Epf,

I have a report which has more than 35k rows, When I run the report from the browser, it's showing Processing .... but the output is not getting displayed. Can you please suggest for this?

We have Installed Latest Version of Seal.

Thanks in Advance.
epf  
#2 Posted : Friday, October 9, 2020 12:29:14 PM(UTC)
epf

Rank: Administration

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

Thanks: 14 times
Was thanked: 159 time(s) in 153 post(s)
There is no real limit on the number of rows... It may depends on your server performances.
We you execute a report, it loads all the records in a DataTable in the server, then use pagination to send the rows to the browser, so you might experience load problems after 10k, 20k, 30k rows returned (depends on the size of the row).
You can view https://stackoverflow.co...-load-into-memory-in-net
saying that we can not exceed 16 777 216 rows.

however you should limit your query using restrictions to avoid this...

thanks 1 user thanked epf for this useful post.
Sujeet Kumar T on 10/9/2020(UTC)
Sujeet Kumar T  
#3 Posted : Friday, October 9, 2020 12:34:48 PM(UTC)
Sujeet Kumar T

Rank: Newbie

Groups: Registered
Joined: 8/12/2019(UTC)
Posts: 6
India
Location: Hyderabad

Thanks: 2 times
Thank you, Eric.
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.