antonioribeiro / antonioribeiro/tracker

High server load and high number of queries

Open
#436 1 comment 2 reactions 0 assignees View on GitHub
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:

![2019-03-18_9-49-06](https://user-images.githubusercontent.com/30681568/54508778-47af4b00-495c-11e9-9d16-bc6a6e4faad3.jpg)
![2019-03-18_9-49-41](https://user-images.githubusercontent.com/30681568/54508795-55fd6700-495c-11e9-95ff-277833a709b9.jpg)

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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.