Skip to main content

Notifications

Microsoft Dynamics RMS forum

RMS v2 + Hotfix 40 / "List Transactions" takes a long time to display transactions

Posted on by Microsoft Employee

Hi folks,

Not sure if this is expected, but we select a 15-day date range or more on the "List Transactions" screen, it takes forever or even most of the time, it just crashes RMS.

Is there a way to speed it up or avoid displaying the transactions, but just allowing us to type in the transaction number and display the transaction if found?

Thanks,

...Alex

*This post is locked for comments

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: RMS v2 + Hotfix 40 / "List Transactions" takes a long time to display transactions

    There are many sites and books on the subject since it is very broad.  It varies on the installation.  Normally I look at hard drive, read/write access, swap file placement, sql total and average memory usage, just to name a few.  

    I have found that ssd drives will help with queries since the drive doesn't have a physical head that it needs to move, making read access far quicker.  Also, you can place the database on its own drive separate from other applications and the OS.  

    Also I recommend trying to only run the essential applications, i.e. no google chrome browsing.  

    There are numerous more ways to tune a database server.  

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: RMS v2 + Hotfix 40 / "List Transactions" takes a long time to display transactions

    Ed,

    Thanks for your response.

    Did you change/tune up something specific on your SQL installation to speed up these slow downs?

    Did you add an index to a table or something to related to this nature?

    Please advise.

    Thanks,

    ...Alex

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: RMS v2 + Hotfix 40 / "List Transactions" takes a long time to display transactions

    Alex

    Sounds like you have a large number of transactions.  Unfortionately the only this is one of the slowest parts of the system.  I have found that if I tune the MS SQL installation then it make these slow downs very minimum.  Also I recommend a SSD drive for the database.  I have one in my laptop and it is very fast and RMS responds very well.

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

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,782 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,067 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,150

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans