开发者

Magento url rewrite re-indexing very slow

开发者 https://www.devze.com 2023-03-05 02:25 出处:网络
A client has a few h开发者_如何学Goundred thousand products in Magento. Whenever client imports new products in (a few hundred each day), Magento needs to re-do the rewriting indexing. This is taking

A client has a few h开发者_如何学Goundred thousand products in Magento. Whenever client imports new products in (a few hundred each day), Magento needs to re-do the rewriting indexing. This is taking a long long time. Is there any way to speed this up, or just have it process only the newly imported items rather than re-doing the entire catalog?


Another option is to look at running a slave web server that talks to the same database. The slave server can do the reindexing (running with apache on 99% CPU) and write the modest amount of updates to the live server, not placing any load on it, maybe 2-3% CPU on mysql calls. In this way you get no performance problems on the frontend server.
Look at the /app/etc/local.xml file for the mysql connection and open up 3306 port on the live server. Then setup a development server to do the 'heavy reindexing'.

0

精彩评论

暂无评论...
验证码 换一张
取 消