| 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.
...
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 100 times faster (from ~200 to ~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) | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|