I'm testing a Magento store (CE 1.7.2) with 180k fake products. A big problem is the reindex time process (reindex all), 2-3hrs. (2hrs with Magento CE 1.8). Has anyone any suggestions about how to speed up the whole process? Thanks
Indexing is core mechanism of Magento which helps to store working properly and fast (flat tables). It is difficult to manage and process so many products(180K) really. And it is really difficult job to implement some solution for indexing process on code level. You should optimize and tune your hardware(memory, processor) and software(MySql, php caches). Here is given great optimizing and performance tricks and try to follow them:
How to optimise database architecture for high volume sites?
Which MySQL Server provides a better performance for Magento
What is the Best Magento Server Setup?
Magento page loading taking too much time