3
 Followers
9
 Likes

Table Records with List_Navigation performance issues

Backend
New

Hello,

  • I am having a Table Records with List_Navigation for the paging purpose.
  • Table Records is associated with aggregate.
  • Line Count of Table Records is 10.

When Page loads Table record displays first 10 row of aggregate but I checked in prepration aggregate fetched 11 row from database id anyone having any idea why aggregate fetching 11 rows first time and when click on next page then it fetching 11+10= 21 rows, It means first time it is fetching Line Count of Table Records +1=11 row.

As per my understanding if I click on page number 5th then aggregate will fetch 51 records in this way there will be performance issue when record count is large so my suggestion is it should be handled in way no matter in which page number user click aggregate/advance sql will fetch only that page data from database to improve performance.


Regards

-SK-

Created on 21 Nov 2018
Comments (2)

We also had similar performance issues.

Changed the category to Backend


views
178
Followers
3