| Info | ||||||
|---|---|---|---|---|---|---|
| ||||||
Although the instructions bellow are valid for all connector version from 6.0.0.0, in the version 6.3.0.1 we introduced two strategies for product and category URL export. For details see Connector Configuration > Product and Category URL Export. In connector version 6.5.0.0 was introduced new mechanism for category-product filter which significantly speeds up export process if you have 20+ export profiles set up and if you use category-product filter for all of them. See corresponding issue for details:
|
Problem
We paid a lot of attention to the performance optimization of the product export process. Thus, our connector is capable of export of 1.7 milion of products in 10.000 categories within couple of minutes.
...
The slow execution of the export process seems to be related to URL attribut export. Magento stores the rewrite rules for URL management and the results are store in table url_rewrite. Sometimes the rows in this table may be outdated and no more necessary. And since the auto clean-up process in Magento is not well implemented, this table may grow and grow without limits, making the export process slower and slower. This sould should help you to increase the speed of Export profile execution:
- Check and mark the number of rows in table url_rewrite.
- Back-up table url_rewrite.~
- Trunkate table url_rewrite.
- Run reindex process in System → Index Management → reindex Catalog URL Rewrites index. The rows in tabke url_rewrite should be repopulated and the number of them should be much lower (compare with step 1).
- Try to run Export profile in Koongo Connector again.
One customer reported that originaly he had in this table 1.2 milion of rows and afterwards just about 200.000 (thus, 6-times less), making the process of Export profile execustion 12 100 times faster (from ~200 to ~15 seconds).~2 seconds)!
How to trunkate url_rewrite table?
- Login to phpMyAdmin
- Click you databse name on the left
- In the right window, click your database name again (up top) it will list all the tables.
- Find the “core_url_rewrite\” table. click the checkbox on the left.
- To the right, click Empty!
- Login to magento, reindex.
Related articles
| Filter by label (Content by label) | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|