Skip to content

SQL Optimization for Injector, getNextTasks #45

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Merged
ppavlovic merged 9 commits into from
Jul 27, 2023
Merged

SQL Optimization for Injector, getNextTasks #45

Changes from all commits
Commits
Show all changes
9 commits
Select commit Hold shift + click to select a range
6c34f67
Added a caching to DiscoveryService
ppavlovic Jul 11, 2023
cef3fb6
Add explicit order by hostname
ppavlovic Jul 11, 2023
f256769
Merge remote-tracking branch 'upstream/master'
ppavlovic Jul 11, 2023
a189803
Added RebalanceService to rebalance tasks from unavailable to availab…
ppavlovic Jul 14, 2023
c44cd73
Merge branch 'g4code:master' into master
ppavlovic Jul 14, 2023
eaadcf0
Added RebalanceService to rebalance tasks from unavailable to availab…
ppavlovic Jul 14, 2023
7844327
Merge branch 'master' into master
ppavlovic Jul 14, 2023
1093583
Merge remote-tracking branch 'upstream/master'
ppavlovic Jul 17, 2023
668d223
Optimization for Injector, getNextTasks
ppavlovic Jul 27, 2023
File filter

Filter by extension

Filter by extension
Conversations
Failed to load comments.
Loading
Jump to
Jump to file
Failed to load files.
Loading
Diff view
Diff view
16 changes: 10 additions & 6 deletions src/Model/Repository/Mysql/RecurringRepository.php
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -19,13 +19,17 @@ public function __construct(\PDO $db)

public function getNextTasks()
{
$query = 'SELECT * FROM ' . Consts::RECURRING_TASKS_TABLE_NAME . ' WHERE status = :status_recu
AND recu_id NOT IN (SELECT DISTINCT tasks.recu_id FROM tasks WHERE status = :status)';
$query = sprintf(
'SELECT * FROM %s
WHERE status=%d
AND recu_id NOT IN (SELECT DISTINCT recu_id FROM %s WHERE status=%d AND recu_id > 0)',
Consts::RECURRING_TASKS_TABLE_NAME,
Consts::RECURRING_TASK_STATUS_ACTIVE,
Consts::TASKS_TABLE_NAME,
Consts::STATUS_PENDING
);

$stmt = $this->pdo->prepare($query);
$stmt->bindValue(':status_recu', \G4\Tasker\Consts::RECURRING_TASK_STATUS_ACTIVE, \PDO::PARAM_INT);
$stmt->bindValue(':status', \G4\Tasker\Consts::STATUS_PENDING, \PDO::PARAM_INT);
$stmt->execute();
$stmt = $this->pdo->query($query);

return array_map(function($data) {
return \G4\Tasker\Model\Domain\Recurring::fromData($data);
Expand Down