Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Usage smartlist is taking 15 minutes to populate

Posted on by 80

Good Morning fellow developers,

i have a smartlist report called "usage" that is under "sales" and its the only report that take more than 10 minutes to populate does anyone of you know the cause and if i can fix this ?

Thanks 

*This post is locked for comments

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Usage smartlist is taking 15 minutes to populate

    If you try this on your server is it any quicker? What speed are your network cards and hubs? If it runs quicker on your server then the issue resides with your network.

  • Ebram Ishak Profile Picture
    Ebram Ishak 80 on at
    RE: Usage smartlist is taking 15 minutes to populate

    i have a lot of memory in the computer that's not the issue.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Usage smartlist is taking 15 minutes to populate

    So is the speed the same across all computers? How much memory do you have in your computer?

  • Ebram Ishak Profile Picture
    Ebram Ishak 80 on at
    RE: Usage smartlist is taking 15 minutes to populate

    yes we tried this already but for some reason its not a network issue

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Usage smartlist is taking 15 minutes to populate

    If you try this on your server or another computer does it take this long? 10 minutes for 1,200 is too long. I would suspect your network as being the issue.

  • Ebram Ishak Profile Picture
    Ebram Ishak 80 on at
    RE: Usage smartlist is taking 15 minutes to populate

    it shows 1200 criteria are being returned , when i start searching on a smaller range it does appear normally within seconds

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Usage smartlist is taking 15 minutes to populate

    How many records are being returned? If you specify a smaller range does it go any quicker?

  • Ebram Ishak Profile Picture
    Ebram Ishak 80 on at
    RE: Usage smartlist is taking 15 minutes to populate

    it takes more time to start displaying line so once i open it , it does take 10 minutes for all the lines to appear.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Usage smartlist is taking 15 minutes to populate

    Does it take a lot of time simply to start displaying lines or simply for the complete list to appear? How many sales orders do you have? If you try search by sales order number with a begin and end range does this help. You could also add the sales doc type. This would force it to use an existing index.

  • Ebram Ishak Profile Picture
    Ebram Ishak 80 on at
    RE: Usage smartlist is taking 15 minutes to populate

    i have no search criteria i go into the smartlist click on usage smartlist , and then i have to wait to 8 to 10 minutes for it to populate then i can put in the search criteria

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans