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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics RMS (Archived)

need a solution to growing customer table in HQ environment

(0) ShareShare
ReportReport
Posted on by

We are working with a HQ Customer with 75 stores and about 1.5 million global customers. The major problem on hand is the delay this causes during the 401s. We have multiple HQ Server feeding into one main db. Is any of the following possible?

1. Split the 401's so the global customer information and sales information are run separately.

2. Remove the customer update as part of the 401's (without disabling global customers)

3. Any other solution that you can think of

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Community Member Profile Picture
    on at

    You cant remove the Customer update part from 401s.  You can check with Retail Realm.  They have a HQ utility addon bundle.  One of the things it is suppose to do is speed up the communication between stores and hq.

  • Suggested answer
    Community Member Profile Picture
    on at

    Hello Pratik,

    Thank you for your question.

    There is no way to remove the customer update function from the Style 401 worksheets within RMS.

    You can try completing the steps outlined in the following blog article to try and increase the performance for the Style 401 worksheets:

    community.dynamics.com/.../improve-401-performance-by-adding-3-indexes-to-hq.aspx

    Thank you,

    Scott Wardzinski

    Microsoft Dynamics RMS & POS Support Engineer

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April 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