I am working on a Symfony2 project. My project uses database to store the data and Doctrine2 to retrieve that data.
As the data within the database has grown the queries became very slow and the whole web app takes about 2 mins to load or does not load at all.
The only way I can see my self fixing this is to cache some queries results but how can I do that. Unless there is different way of dealing with such issue.
See Question&Answers more detail:os