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

Notification

Icon
Error

Options
Go to last post Go to first unread
Jeff  
#1 Posted : Monday, June 20, 2022 5:31:23 AM(UTC)
Jeff

Rank: Newbie

Groups: Registered
Joined: 3/9/2022(UTC)
Posts: 2
Australia
Location: North

Thanks: 1 times
Hi,

The only information I can find on "Server Pagination" is:

Data Tables: Server Pagination
By default and for performances reason, tables are displayed using server pagination, this means that the cell values of a page are sent to the browser when the user click on a page number. (Refer to Data Tables Server Side processing for more information).
For a report, the server pagination can be enabled or disabled using the root view parameter Options: Server Pagination Enabled.

Obviously we can implement some restrictions, however we were hoping to avoid this.

To prevent timeouts, we would like to implement TSQL paging (Fetch/Offset) on our queries. It is unclear from the documentation but I suspect that "Server Pagination" in the above context must refer to the seal reports server, rather than SQL, as we are not seeing paging queries hit the database.

Can someone please offer some advice on how best to implement such paging.

epf  
#2 Posted : Tuesday, June 21, 2022 8:57:10 AM(UTC)
epf

Rank: Administration

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

Thanks: 14 times
Was thanked: 183 time(s) in 176 post(s)
Hello, I confirm that the Server Pagination is done on the Web Server and not on the Database server.

Implementing a SQL Paging would require an evolution (specific to each database server (MS SQLServer first ?)) of the product,
could be a nice feature/pull request...

feel free to contribute.




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.