I am having an online app regarding leisure activities, where I have a big amount of providers in the backend, who create their own activities and offer those via my platform. In order to achieve this, I am making heavy use (naturally) of the database. Fortunately now, this has caught quite some interest. Unfortunately though… the interest causes the database heavily to go to its knees, and it already takes forever now to load all the different page elements (though the page itself is quite optimized for speed).
Does anybode have any experience / tricks, how the db load speed for pages can be optimized. Already tried pagination… but unfortunately this failed bitterly (so I did not even deploy).
You can see the page on the following link: