Calculating a large number of MYSQL queries as customshort codes, slow
I am using wordpress and building a dashboard. There are a lot of complex MYSQL queries that I am running in order to return results from the DB. I am returning these as custom short codes in wordpress, with each query as its own function. That seems to be causing the page to take A LONG time to load >15seconds each time. Is there a better way to do this that would be faster? My customer shortcodes .php file is about 1500 lines long with about 50 calculations. Not all are used on the same dashboard tab, but obviously it is running each in order to get through the ones it needs.