How do I speedup the import/export process within Magento?

As with anything Magento does require ongoing maintenance to keep working smoothly and efficiently. Fortunately, the process is very easy and can be accomplished within only a few steps. Please see below for more details.

The below-mentioned tables within your Magento installation database are the reason for most slowdowns that happen within your Magento installation. To resolve these issues, we recommend periodically clearing out these tables:

  • log_url index_event
  • dataflow_batch_export
  • log_visitor
  • log_url_info
  • report_event
  • dataflow_batch_import
  • log_visitor_info

To accomplish the above-mentioned task of clearing out the data located within the tables, we've created a step-by-step guide on how this can be accomplished:

Finally, click on the "Go" button to run the query

Should you have any additional questions pertaining to your Magento hosting account, please feel free to reach out to our web hosting support team for additional guidance.

  • Login to your cPanel web hosting account
  • Locate the section entitled "Databases"
  • Next, click on the "PHPMyAdmin" icon
  • On the left hand side, choose the Magento database
  • Once loaded, on the top menu, click on "SQL" and paste:
    • 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`;

Should you have any additional questions pertaining to your Magento hosting account, please feel free to get in contact with ourĀ web hosting support team for additional assistance.