hi there, `spy_oms_order_item_state_history` and `spy_oms_transition_log` are the biggest tables in

UKK0LRJ6A

hi there,

spy_oms_order_item_state_history and spy_oms_transition_log are the biggest tables in our database. Is it safe + is it ok to remove old entries from both tables?

e.g. with:

DELETE FROM
    spy_oms_transition_log
WHERE
    created_at < CURRENT_DATE - interval '90' day;

Ehsan Zanjani

Hey @UKK0LRJ6A
I think OrderDetail page is using the state-history table to show the order items with status history, so if you delete them you won’t see order items, this can be fixed by changing the join type from inner to left in one of the query, I don’t remember it honestly. 🙂
Transition logs are stored in DB just for debugging reason in OMS, so if you don’t have any issue with old orders feel free to remove them!

Ehsan Zanjani

Also please don’t delete the old orders without any track back, you can export them to an archive storage

UKK0LRJ6A

thanks @UK9N7MP96! is there already a public extension to move old orders into a archive storage?

Ehsan Zanjani

You can just easily export a dump and extract it into a different DB (off production), nothing specials and it could also be a monthly script/job

UKK0LRJ6A

thanks!