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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics RMS (Archived) / RMS v2 + Hotfix 40 / &...
Microsoft Dynamics RMS (Archived)

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

(0) ShareShare
ReportReport
Posted on by Community Member

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

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    Community Member 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 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 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

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

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

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics RMS (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans