Magento product imports and exports tend to gradually slow down. The reason for this usually is that the Magento database fills up with records and the larger it becomes, the slower product imports and exports become.
Fortunately, there is an easy solution. To reduce the database size and speed up product imports and exports, you can delete old records by truncating a few tables. The tables that need to be truncated are log_url, log_url_info, log_visitor, log_visitor_info, dataflow_batch_import,dataflow_batch_export, index_event and report_event.
You can truncate these tables through phpMyAdmin. Simply tick the 8 tables and from the With selected drop-down menu at the bottom of the page select Empty.
An alternative of the above is to click the SQL tab in phpMyAdmin, paste these queries:
TRUNCATE `log_url`; TRUNCATE `log_url_info`; TRUNCATE `log_visitor`; TRUNCATE `log_visitor_info`; TRUNCATE `dataflow_batch_import`; TRUNCATE `dataflow_batch_export`; TRUNCATE `index_event`; TRUNCATE `report_event`;
and click the Go button to execute them.
It is also recommended that you set up log cleaning in Magento so that your Magento can purge its logs automatically.
Posted in: Magento