I have a cronjob that does a reindexall for all indexes in my magento setup, and it takes more than 6 hours to finish the job, making the server slower to respond during that period.
Since flat tables are another way to store data, I wonder what I can do to optimize this process, and I have the following questions: