This involves working out what your site is doing and improving indexing within MySql to have the task it will be doing, ready before it begins.....this means you need a good server to begin...yet in the long run you are reducing MySql quires...which take far longer and providing the end user with the speed they need....as you are seeing on this site...

Quote: