Skip to main content
Dynamics 365 Community / Forums / Commerce forum / Offline Database data ...
Commerce forum
Suggested answer

Offline Database data - to many data records

editSubscribe (0) ShareShare
ReportReport
Posted on by 17
Hi experts, 

is there a way to limit the data that is synchronized to the offline database of the cash register? 
Currently, for example, all INVENTDIM data records are transferred even if they are not all used on the cash register, which leads to unnecessary memory usage. 

Thanks!
Attachments
  • Shafeeque Mohammed Profile Picture
    Shafeeque Mohammed 6,016 Super User on at
    Offline Database data - to many data records
    The compression won't happen immediately after activation.. Make sure that you have configured the store hours as well. On the second link, there are some commands to enable compression at table level as well. 
     
     
     
     
    Also, consider running, inventory dimensions cleanup in batch to make sure that you have only active records in the INVENTDIM table in HQ.

    "If my response was helpful, please consider marking it as verified. You'll earn 2 points 🌟, and I'll get 5 points 🙏. Thank you! 😊"

  • chbtn Profile Picture
    chbtn 17 on at
    Offline Database data - to many data records
    Thanks for the quick reply.

    The assortment is well selected but the size of Records and Indexes is insane. 
    I have also enabled the compression feature. 

    Do you have any other ideas? Is there anything to consider after the feature has been activated?



    Thank you. 
  • Suggested answer
    Shafeeque Mohammed Profile Picture
    Shafeeque Mohammed 6,016 Super User on at
    Offline Database data - to many data records
    This is an issue that we often face especially when you are using SQL Express for offline DBs. InventDIM is not something you can completely remove from offline channel DB. Some tips we tried and helped are- 
    1.  Housekeeping the assortment - Retailers usually add a category to assortments which will flood the assortment with items that you dont sell anymore. We recommend frequent housekeeping to mark a product as stopped if it is not in stock and will not be sold anymore. Process assortment will skip these items and the data related to these items will not be sent to channel DB.
    2. Enable POS offline database Compression in feature management -  https://learn.microsoft.com/en-us/dynamics365/commerce/dev-itpro/cdx-best-practices#enable-table-and-index-compression 
    3. Also, refer - https://learn.microsoft.com/en-us/dynamics365/commerce/dev-itpro/cdx-best-practices
     

Helpful resources

Quick Links

What Motivates a Super User?

We know many of you visit the Dynamics 365 Community and Power Platform…

Demystifying Copilot with Georg Glantschnig…

Industry experts answer burning questions directly from our amazing Community…

Setting Up Knowledge Sources for Copilot…

Look at how configuring a comprehensive knowledge base is crucial…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,080 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,601 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Featured topics

Product updates

Dynamics 365 release plans