Store Commerce :: Offline DB size is huge.

(0) Share

Report

Posted on by MA-11111252-0

Hi everyone,

One of our clients is experiencing large DB size of offline database of around 35 GB in Store Commerce. Mainly it is because huge size of "InventDim" in 1040 and "LogisticPostalAddress" in 1010.

For 1040 or "InventDim" in particular, i have run multiple jobs of historical data cleansing including "Clean up unused inventory dimensions" or "On-hand entries cleanup" or a few more in Inventory Management. It did reduce the table size to InventDim but DB size could not be reduced.

For 1010, if i exclude this table "LogisticPostalAddress", it throws error while logging in to POS.

Is there anything else that i can perform to reduce the data packet size of these tables without hurting the any operation in offline and Online functionality.

Categories:

Dynamics 365 Commerce

Dynamics 365 Supply Chain Management