The speed of your Magento shop is very important. A slow and bulky website always takes your customers away. Magento optimisation, here is a way to do it.
It happened to me that I wanted to reindex the product flat data and I got a PDOException, you can see the whole reindex error message bellow. I tried