How to archive old orders in Drupal Commerce I have a site with more than 15000 commerce orders. This is slowing down the site drastically. I have upgraded all the modules and applied the patches regarding the table locking and so on. They haven't been of much help.

I am ok with removing the order history from the site. I just want to keep an archive of that so that I can use them once I have enough resources to handle everything. 

I am not able to get the site up. Hence I will have to do all the work from the command line. So is there any safe and suggested way to archive the orders?
Couldn't you just backup your database using phpmyadmin, doing a .mysql export of the whole database which would keep record of all orders in the commerce_order and commerce_customer_profile tables?

Then using phpmyadmin, just remove all rows from the commerce_order table, to wipe the slate clean.

In the future, if you wanted to add all orders back into the site, you could import the data from your backup.