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 :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Released Products exte...
Microsoft Dynamics AX (Archived)

Released Products extended form is very slow

(0) ShareShare
ReportReport
Posted on by reachnaidu 890

Hi 

We have a problem when loading released product extended form .. we have around 100k released products for Company A and the Extended form loads fine in few seconds. We moved the same release products to Company B and the Released products screen (by Company) loads fast but the extended form is hard hit and loads after considerable amount of time (around 30 s - 1 min). We have reindexed and did other checks to see for missing Indexes but nothing works out. But when filter the extended form with just one item Id the form loads fast.. but the design of the form (base ax) was to load all the items for a company and filter and show the item which we selected in the previous screen .. Does any one come across this problem ? Please suggest if there are any options.

Thanks 

*This post is locked for comments

I have the same question (0)
  • Martin Dráb Profile Picture
    Martin Dráb 236,289 Most Valuable Professional on at
    RE: Released Products extended form is very slow

    I would use Trace Parser (and execution plans, if it happens to be caused by a query) to identify what exactly is taking such a long time.

  • reachnaidu Profile Picture
    reachnaidu 890 on at
    RE: Released Products extended form is very slow

    Thanks for the reply. We tried all the options and found no table scans or missing indexes. Also half of the time is used by query and another half for filtering the entire dataset to one item at the form level. Had any one faced this problem ? We loaded the released products to another company through DIF

  • Suggested answer
    Vilmos Kintera Profile Picture
    Vilmos Kintera 46,149 on at
    RE: Released Products extended form is very slow

    Have you enabled dataarealiteral setting to generate separate query plans for each company? That is a recommended practice for building correct table statistics if you are in a multi-company environment for improving SQL select performance.

    https://blogs.msdn.microsoft.com/axinthefield/sql-server-parameter-sniffing-with-dynamics-ax-just-plain-evil-redux-5-19-2014/

  • reachnaidu Profile Picture
    reachnaidu 890 on at
    RE: Released Products extended form is very slow

    we are already in R3 . The link seems to be talking about R2

  • Suggested answer
    Vilmos Kintera Profile Picture
    Vilmos Kintera 46,149 on at
    RE: Released Products extended form is very slow

    It is relevant for all, if you do not believe me here is another link: https://blogs.msdn.microsoft.com/axsupport/2015/11/24/how-to-proactively-avoid-parameter-sniffing-step-by-step/

    Please check the setting...

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

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…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Community Member Profile Picture

Community Member 4

#2
Nayyar Siddiqi Profile Picture

Nayyar Siddiqi 2

#2
Guy Terry Profile Picture

Guy Terry 2 Moderator

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans