I have created a full migration migrating data from their old, non SQL based, ERP system to Dolibarr. Running this migrating now every night till we go live in around one year including daily stock correction.
Everything looks great so far, except the 3 tables actioncomm actioncomm_resources and stock_mouvement are blowing up themselfs.
does it hurt dolibarr if i cleanout this 3 daily before the migration prozess starts? I have not found any tool in Admin tools to cleanup tese tables and mine have > 1 Mio records meanwhile.
You can clean this table. You will just lose history information.
For stock, the stock at date may also be limited to a date where stock movement was not deletedto have good value.
Stock at date is calculated from current stock of product with delta of all stock movement between the date and now.
Hey Vstrecker,
Sounds like a solid migration setup overall. I’ve dealt with similar growth issues in those same tables during recurring imports. As ELDY mentioned, clearing them is fine if you’re okay with losing that history, but for stock, mouvement especially, just be cautious if you’re planning to use features that rely on historical stock levels. You might want to archive or export a snapshot periodically before cleaning, just in case you need to reference something down the line.
