Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics RMS (Archived) / need a solution to gro...
Microsoft Dynamics RMS (Archived)

need a solution to growing customer table in HQ environment

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

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

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee 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
    Community Member Microsoft Employee 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

photo of Muhammad Affan

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

thumbnail image of a pie chart section

Top 10 leaders for November!

Congratulations to our November super stars!

thumbnail image of the word Tip

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,503 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans