Hiya!
An issue I've encountered with my phpVMS-based website. We're experiencing significant loading times, often between 10 to 15 seconds, which we believe is impacting user experience negatively.
Our database is quite extensive, containing around 16,000 flights. Upon investigating the issue using Laravel Debugbar, we discovered that a large number of duplicated SQL statements are being executed. Here's a brief overview of what we're seeing:
Total statements executed when loading the flights page: 112 (85 of which are duplicates, 27 unique)
Example duplicated query: select 'name', 'enabled' from 'modules' (This is executed multiple times for different module names.)
Loading times for the 'GET flights' request: Approximately 6.53 seconds
We have tried to optimize our database and application code as much as possible but are still facing these high loading times due to the duplicated queries.
I'm looking for any advice or strategies you might have for dealing with these issues. Specifically, I'm interested in ways to reduce these duplicated statements and optimize the overall performance of the application. Here are some questions I have:
Are there known best practices within the phpVMS community for optimizing large databases and reducing query duplication?
Has anyone else experienced similar performance issues, and if so, how were you able to resolve them?
Are there any specific tools or plugins recommended for analyzing and optimizing performance in a phpVMS setup?
Any insights, experiences, or recommendations would be greatly appreciated. I'm eager to learn from the community and find effective solutions to improve our site's performance.
Regards!
Joost