cscart_order_data is too big , I have 767274 row. How can I make database small?
There is a related discussion in this thread that can be useful, but it is in Russian, you can try using Google translate to translate the whole page.
Basically, you can either archive the old orders data, delete this data partially or fully, optimize the tables or use a combination of those measures.
We at Customer Care can provide you with a script that can remove redundant shipping data from the order data. This is usually the largest part of the data stored in this table. However, it won’t reduce the number of rows stored in this table, because deleting them will affect the data of orders placed in your store.
If you are interested, please contact us via Help Desk.