antonioribeiro / antonioribeiro/tracker
High server load and high number of queries
- Dominant language
- PHP
- Stars
- 2.9k
- Forks
- 594
- PR merge metrics
- No merged PRs in 30d
Description
I've disabled many parts of this package from the config file.
'log_sql_queries' => false,
'log_sql_queries_bindings' => false,
'log_events' => false,
'log_geoip' => false,
'log_user_agents' => false,
'log_devices' => false,
'log_languages' => false,
'log_referers' => false,
'log_queries' => false,
But sometimes there are queries that are related to the disabled settings.
These queries are run on one page:


When a part of the config is disabled, the relevant query should not be executed.
Please optimize this package and use eager loading as much as possible.
Contributor guide
No contributing guide indexed for this repository
Research direction
Start by reproducing the reported page with the listed configuration settings disabled and inspect the queries shown in the attached screenshots. Trace each query back to the disabled setting and verify that those queries are not executed; assess whether eager loading reduces the remaining query and server load.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- laravel, php
- Domain
- backend, databases, performance
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100