Hi, I have a big project that has been running well for at least 2 years. On my project I have an issue about overload database connection in certain API that i dont use the database to fullfill of API itself,
went I tracing log of laravel queries in the API, there were some of table such as system_plugins_version and offline_sentry making query select, how to handle that query to database is not getting called?
any other reason, I have some API that calling the external API provided by third party, the purpose is to handling the data make adjustment to my app, when it goes so slow to get, my queries have a long open connection for so long also.
When I compare it to Laravel itself, there’s no queries when i returning the static response. Is it able to do that? probably it will work to reduce the active connection of the database.
I’m not make a decision to change other framework for this issue, all the features in octobercms have been used by many things for this project.
currently not sure, if this is possieble, but, i thinking about “breaking” a lifecycle of APP and return response before any plugin or app can do anything… maybe in plugin with routes.php file, where you can do anything without any distraction of app.
The first thing to do would be to try to upgrade to the latest version. October CMS is constantly improving, especially in the past two years, it has been worked on more than the first seven years.
I know v3 has better caching to reduce these queries; specifically, the “information schema” query is gone in version 3.
If you are using a Laravel route, then under normal circumstances, it should not result in extra queries. If this is coming from the OFFLINE Sentry plugin, then contacting them about uncached queries on Laravel routes could be useful.
But first, upgrading is the best path to see if this has already been resolved by core improvements.