Thanks for this article. I'm new to Magento and the re-indexing is driving me crazy. I'm making a lot of changes to my (imported) catalog at the moment and I just want to be able to see how that looks, but then I have to re-index (for days) before the stuff shows up on the front end. In the meantime I have broken links.

When you re-index, can you continue to use the admin area and the site? Or do you have to have to stay out of it?

when you do re-index, actually, it will re index the data's, so it may possible as you told, (link broken) on frontend and on backend it gives error of processing, keep practice to avoid to access such menu's which you put for reindex (like catalog).

Indeed when a large number of goods or attributes need to be saved, backend works very slow, as each time you save data the system re-indexes the goods through the entire catalog.

Asynchronous Re-indexing is a solution of this problem. When a product or category is saved it is not immediately re-indexed, but put into a queue. The queue is re-indexed in the background. This greatly speeds up the backend. This mechanism is implemented by using an extension of http://mirasvit.com/magento-extensions/magento-asynchronous-reindex.html.

Even in case you place online shop even on a good hosting, sometimes the products, categories and attributes are saved slowly. This is due to the need to clear the cache and run re-indexing of stored items.

Hey Guys,We just published an extension that addresses reindexer timouts (through the browser) by utilizing the Magento Cron job. Come take a look! http://www.magentocommerce.com/magento-connect/catalog/product/view/id/18404/

Hey thanks for sharing this trick. I would wish you to have a look at this post as well which will be helpful http://magedeveloper.wordpress.com/2012/08/16/magento-reindexing-problem-take-too-long-time/ Thanks for sharing this. I just recently tried out this issue when I have been installing Magento product reviews extension and then I found this very helpful and rectified.

Having a lot of problems with trying to index product flat data. I've trawled the forum for hours trying the various methods that have worked for others. I tried your non ssh method but came up with this.load($index); $process->reindexAll(); } ?>

Has anyone got any ideas. I've also tried the reindexall method via a cron job, but I can't tell if it ran successfully or not - just get an email to say it ran but I can't find anywhere to say that it was succesful or otherwise. I'm starting to round in circles with this. Ver.1.7.0.2

Above error is because of foreign key constraint. There is relations between two tables and due to that it not allow to add/update row if that record not exit on master table. Set foreign key check constraint null by using below command and try to execute again.SET foreign_key_checks = 0;

I tried to reindex using the reindex.php way as i am a bit confused as how to it wil the command promt but when i ran the file through my browser i get the same message as i do when i run it through the back end

"Request Timeout"

"This request takes too long to process, it is timed out by the server. If it should not be timed out, please contact administrator of this web site to increase 'Connection Timeout'."

Please help as nothing is being returned in my store when i search for the product names or SKU codes. This is very fustrating as my store is meant to go live by the end of this week.