web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

AX 2012 opens the released products menu items open it very slowly.

(6) ShareShare
ReportReport
Posted on by 18
When the user opens the released products menu items, it is very slow and takes about 3 minutes to open it. so how can i solve it ?
 
thanks
Categories:
I have the same question (0)
  • Suggested answer
    Arvind Bharti Profile Picture
    590 Super User 2025 Season 2 on at
    AX 2012 opens the released products menu items open it very slowly.
    Hi,
     
    This would defintely require analysis from technical team.
     
    Do you have any customization on this list page or form which is getting displayed using some logic?
     
    May be reach out to technical consultant in your team to idetnifiy what is causing delay
  • Verified answer
    Adis Profile Picture
    5,691 Super User 2025 Season 2 on at
    AX 2012 opens the released products menu items open it very slowly.
    Hey,
     
    I guess you have custom code somewhere? One reason could be that when you open it there is information from other tables. If the query that pulls the data is not optimized or the DB in general is not optimized it can lead to very slow queries, ie. opening the form.
     
    Even without custom code its hard to determine where this is coming from as the amount of data is different from each company.
     
    Although, its not a quick solution, however, still the quickest would be to debug this and check which part of the query takes the most.
     

    Kind regards, Adis

     

    If this helped, please mark it as "Verified" for others facing the same issue

    Keep in mind that it is possible to mark more than one answer as verified

  • Verified answer
    Zain Mehmood Profile Picture
    4,173 Most Valuable Professional on at
    AX 2012 opens the released products menu items open it very slowly.

    Hi,

    If the Released products form in AX 2012 takes several minutes to open, it’s likely due to performance or capacity issues. Common causes include:

     

    Too many records loading without filters — try opening with filters (Ctrl+G).

    Heavy display methods or joins on the form — these can slow performance, especially on large datasets.

    SQL performance/capacity — check for missing indexes or high table size (e.g., InventTable, EcoResProduct).

    AOS or SQL server load — system capacity (CPU/memory) might be strained during peak usage.

    Customizations — review any custom logic in form init() or data sources.

    You may also want to run a SQL Profiler trace or use Trace Parser to pinpoint the exact delay.

    Warm Regards,

    Zain 

  • Suggested answer
    CU30040216-0 Profile Picture
    18 on at
    AX 2012 opens the released products menu items open it very slowly.
    Thank you for your responses. We have asked the consultant to handle it。

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 2,188

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 868 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 593 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans