Rank: Newbie
Groups: Registered
Joined: 4/30/2020(UTC) Posts: 2 Location: Merano Thanks: 1 times
|
Hi.
I am reading an SQL table with 100,000 records into a table control.
How can I implement paging? Only the records necessary for display should be read from the SQL Server. When scrolling in the control, the next records should then be read.
Thanks, Peter
|
|
|
|
Rank: Administration
Groups: Registered, Administrators Joined: 7/21/2014(UTC) Posts: 498
Was thanked: 88 time(s) in 88 post(s)
|
1. Use TOP ... in your SQL statement to limit amount of retrieved rows to some reasonable max, like 500 2. Use Row Group Chunk Size setting in the table in MobileTogether so that the table is built chunk wize - typical chunk sizes are 20-25 https://www.altova.com/m...s_tables_properties.html
|
1 user thanked bbv for this useful post.
|
|
|
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.