Performance: N+1 queries in renderTemplate() for category/author/tags #117

New Issue

2026-06-06T11:50:09Z

jmiller commented

2026-06-06 11:50:09 +00:00

Audit Finding

Severity: Medium

Issue:
Each call to renderTemplate() executes separate queries for category name, author name, and tags. With 10 services, that's 30 redundant queries since the article data hasn't changed.

Fix: Pre-load category, author, tags once before the service loop in dispatch() and pass to renderTemplate().

Files: CrossPostDispatcher.php

## Audit Finding **Severity:** Medium **Issue:** Each call to `renderTemplate()` executes separate queries for category name, author name, and tags. With 10 services, that's 30 redundant queries since the article data hasn't changed. **Fix:** Pre-load category, author, tags once before the service loop in `dispatch()` and pass to `renderTemplate()`. **Files:** `CrossPostDispatcher.php`

jmiller commented

2026-06-06 11:50:13 +00:00

Branch created: feature/117-performance-n-1-queries-in-rendertemplat

git fetch origin
git checkout feature/117-performance-n-1-queries-in-rendertemplat

Branch created: [`feature/117-performance-n-1-queries-in-rendertemplat`](https://git.mokoconsulting.tech/MokoConsulting/MokoJoomCross/src/branch/feature/117-performance-n-1-queries-in-rendertemplat) ```bash git fetch origin git checkout feature/117-performance-n-1-queries-in-rendertemplat ```

jmiller referenced this issue from a commit

2026-06-06 14:56:38 +00:00

feat: resolve 6 enhancement issues (#116-#119, #124, #125)

jmiller closed this issue

2026-06-06 14:56:55 +00:00

Sign in to join this conversation.

Priority -

Type —

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: MokoConsulting/MokoJoomCross#117