How to speed up product imports/exports and decrease database size in Magento

2
43
views
Advertisement

To speed up magento products imports/exports and make database size decrease please run following query in your Magento database :

TRUNCATE dataflow_batch_export;
TRUNCATE dataflow_batch_import;
TRUNCATE log_customer;
TRUNCATE log_quote;
TRUNCATE log_summary;
TRUNCATE log_summary_type;
TRUNCATE log_url;
TRUNCATE log_url_info;
TRUNCATE log_visitor;
TRUNCATE log_visitor_info;
TRUNCATE log_visitor_online;
TRUNCATE report_viewed_product_index;
TRUNCATE report_compared_product_index;
TRUNCATE report_event;
TRUNCATE index_event;
TRUNCATE catalog_compare_item;
TRUNCATE catalogindex_aggregation;
TRUNCATE catalogindex_aggregation_tag;
TRUNCATE catalogindex_aggregation_to_tag;

Thanks for reading my blog. I hope it will help you, Please leave your comments here if it’s really help you. 🙂

Thank You :),
Mayank Zalavadia

2 COMMENTS