Page takes too long to load data

jimmyfjimmyf Member Posts: 103
edited 2015-10-28 in NAV Three Tier
I have a list page which displays data from the G/L entry table. The page hangs when loading as there are over 5 million records in the table. Is there any way to allow users to apply filters before the page loads data?
This is Nav 2013 on SQL server 2012.


  • Options
    belindasphotobelindasphoto Member Posts: 4
    Maybe you can preset a filter to open the page first and allow user to revise the filters?
    Otherwise, you need call page.runmodal from another page.
  • Options
    krikikriki Member, Moderator Posts: 9,096
    [Topic moved from 'NAV Tips & Tricks' forum to 'NAV Three Tier' forum]
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • Options
    AventselAventsel Member Posts: 1
    You can preset filters on opening page, just write the code on the OnOpenPage trigger:

    I believe this can decrease the scope of record to show and increase performance. Then user can revise filters.
Sign In or Register to comment.