Microsoft Dynamics AX Support

This blog contains posts by the Microsoft Dynamics AX Support teams Worldwide

AX2012 List Pages - Performance Improvement

AX2012 List Pages - Performance Improvement

Rate This
  • Comments 1

I’ve been working on some performance issues recently, and some of these were related to list page performance in AX 2012. The problem is that for some of the list pages, even with CU3, the main query performance is slow due to the fact that the query parameter OPTION(FAST) is not being added automatically to the SQL statement, as it does with most standard forms in Dynamics AX. For some customers this does not create a performance problem, but others may experience slowness opening the list-pages due to their data constellation. I’ve identified some of the list pages where this could be a problem, see the workaround notes below:

Vendor List Page

Object: Query > VendTableListPage > Data Sources > VendTable

clip_image001

Change the “FirstFast” property on the “VendTable” in this view to “Yes”.

clip_image002

Sales Table List Page

Object: Query > SalesTableListPage > Data Sources > SalesTable

clip_image003

Change the “FirstFast” property on the “SalesTable” in this view to “Yes”.

clip_image004

Released Product List Page

Object: Query > EcoResProductPerCompanyListPage > Data Sources > InventTable

clip_image005

Change the “FirstFast” property on the “InventTable” in this view to “Yes”.

clip_image006

Main Accounts List Page

Object: Query > MainAccountsListPage > Data Sources > MainAccount

clip_image007

Change the “FirstFast” property on the “MainAccount” in this view to “Yes”.

clip_image008

CustTable List Page

Object: Query > MainAccountsListPage > Data Sources > CustTable

clip_image009

Change the “FirstFast” property on the “CustTable” in this view to “Yes”.

clip_image010

Ledger Trial Balance List Page

Object: Query > LedgerTrialBalanceListPage > Data Sources > DimAttrvalueCombo

clip_image011

Change the “FirstFast” property on the “DimAttrvalueCombo” in this view to “Yes”.

clip_image012

Leave a Comment
  • Please add 7 and 1 and type the answer here:
  • Post
  • Interesting finding :-)

Page 1 of 1 (1 items)