Handle large amount of records

Hello All,

I have a standard form of TaxTransactionHistorySummary in Payroll module in AX 2012 R2 which have around 4 million records in it. 

When i open the form, it takes around 5 minutes to open and when i checked the Form Data source comprises of 2 views and 2 queries in it.

I wanted to ask if there's a better way to improve the performance of the form or how can i handle this much amount of bulk data.

Pleases suggest.

Related
Recommended