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

Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Performance of view
Microsoft Dynamics AX (Archived)

Performance of view

(0) ShareShare
ReportReport
Posted on by Community Member

Hi,

A new lookup has been created for a field by overriding the Lookup method on the Form level.

The issue is that it takes around 14 seconds to open the Lookup.

Upon investigation, it is found that the Lookup is using a View as its DataSource and hence the delay for calculation.

Is there any way to optimize the lookup so that it could load faster?

PS - I have used a Query to get the View and added only the requisite number of fields.

*This post is locked for comments

I have the same question (0)
  • Martin Dráb Profile Picture
    Martin Dráb 239,684 Most Valuable Professional on at

    Is the view so slow if you open it directly? If so, look at the underlying query and optimize it. If not, it seems that something else is to blame and you should look again at the query used by the lookup.

  • Community Member Profile Picture
    Community Member on at

    Hi Martin,

    Thanks for your reply. Yes, the view itself is taking around 12 seconds to open.

    In the underlying query, I have already taken only 5 fields out of a possible 300. What else can be done to optimize it further?

  • Martin Dráb Profile Picture
    Martin Dráb 239,684 Most Valuable Professional on at

    I can't tell what's wrong in your query, because I have no information about it. But in general, you may have wrong join conditions (e.g. getting Cartesian product instead of your intended join), missing indexes, filters that can't be indexed and many other things. Run the query in SSMS and look at its execution plan. It may also suggest some indexes to add.

  • Community Member Profile Picture
    Community Member on at

    Okay. Will run the query in SSMS and check.

    Thanks.

  • Dick Wenning Profile Picture
    Dick Wenning 8,705 Moderator on at

    execute the view on SQL an press the button

    do you get missing index hints

    4377.sql.PNG

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

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
CP04-islander Profile Picture

CP04-islander 21

#2
dserp Profile Picture

dserp 4

#2
dekion Profile Picture

dekion 4

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans