as per our architecture, we have a web server(Apache) running on one machine and my database(MySQL) running on different machine. The communication between these two machines in over internal network (without any firewall or any gateway).
We have a database heavy site with around 3000 products and the number is expected to grow. But the problem is that the site is taking too much of time to load (~30 sec). the waterfall diagram in browser shows that first response from server takes around 24-25 seconds and then the complete page loads in 30 seconds.
Images of the products are not heavy and also there is no need for CDN as the server location is in same geographical area.
the site is hosted on a private cloud
the score on GTMetrix is 96%
Any pointers to debug the issue will be much appreciated