MokoConsulting/MokoJoomCross
1
0
Fork 0
Code Issues 32 Pull Requests Releases 1 Wiki Activity

Performance: N+1 queries in processEvergreen() #116

New Issue
Closed
opened 2026-06-06 11:50:09 +00:00 by jmiller · 1 comment
jmiller commented 2026-06-06 11:50:09 +00:00
Owner
Copy Link
Copy Source

Audit Finding

Severity: Medium

Issue:
processEvergreen() executes 2 queries per article-service combination (last posted_at + duplicate guard). For 50 evergreen articles x 10 services = 1000 queries.

Fix: Pre-load latest posted_at and existing queued posts in two batch queries, then filter in PHP.

Files: QueueProcessor.php

## Audit Finding **Severity:** Medium **Issue:** `processEvergreen()` executes 2 queries per article-service combination (last posted_at + duplicate guard). For 50 evergreen articles x 10 services = 1000 queries. **Fix:** Pre-load latest `posted_at` and existing queued posts in two batch queries, then filter in PHP. **Files:** `QueueProcessor.php`
jmiller commented 2026-06-06 11:50:13 +00:00
Author
Owner
Copy Link
Copy Source

Branch created: feature/116-performance-n-1-queries-in-processevergr

git fetch origin
git checkout feature/116-performance-n-1-queries-in-processevergr
Branch created: [`feature/116-performance-n-1-queries-in-processevergr`](https://git.mokoconsulting.tech/MokoConsulting/MokoJoomCross/src/branch/feature/116-performance-n-1-queries-in-processevergr) ```bash git fetch origin git checkout feature/116-performance-n-1-queries-in-processevergr ```
Sign in to join this conversation.
Labels
No items
No labels
Priority -
Type -
Milestone
No items
No Milestone
Assignees
Clear assignees
jmiller (Jonathan Miller)
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: MokoConsulting/MokoJoomCross#116
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?