Magento url rewrite re-indexing very slow
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'.
精彩评论