Does High Volume Stock Ledger Records impact DB Performance


We are seeing our stock leger records crossing 1.6 million and exponentially increasing. We are also seeing a dip in DB performance with frequent deadlocks or lock wait timeout issue happening.

Can these issues and the high volume stock ledger records be co-related?
Do we need to reset the stock ledger at some periodic intervals(like financial year starting etc?

Any suggestion to approach the situation is appreciated?


Upgrade to v13 it has slew of performance fixes for stock transactions. Those won’t/can’t be ported over to v12.