I have a Shop with 50,000 Products multi-linked in 27,000 Categories. (The Database has a products_to_categories index about 950.000)
It is hosted on a good single Root-Server. What changes can I do (In the Code, Database,...) to increase the performance? Cache is active, but the side has a "server respond time" about 5-20 seconds.
Some Ideas? Maybe to improve the Database Index?