...
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) | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|