Page takes too long to load data

jimmyf

Hi
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.

belindasphoto

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.

kriki

[Topic moved from 'NAV Tips & Tricks' forum to 'NAV Three Tier' forum]

Aventsel

You can preset filters on opening page, just write the code on the OnOpenPage trigger:
SETRANGE("Posting Date",CALCDATE('<-CY>',WORKDATE),CALCDATE('<CY>',WORKDATE);

I believe this can decrease the scope of record to show and increase performance. Then user can revise filters.