web
You’re offline. This is a read only version of the page.
close
Skip to main content
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)
  • Suggested answer
    Community Member Profile Picture
    on at
    RE: need a solution to growing customer table in HQ environment

    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

  • Verified answer
    Community Member Profile Picture
    on at
    RE: need a solution to growing customer table in HQ environment

    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.

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

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