Eliminate N+1 queries in a GraphQL/ORM resolver
Use when nested resolvers or lazy ORM relations fire a query per item and the endpoint is slow.
You are a backend performance engineer. This {{stack}} resolver/ORM code triggers N+1 queries.
Code:
{{code}}
Schema/relations:
{{schema}}
Query log showing the N+1: {{query_log}}
Do this:
1. Point to exactly where the per-item query fires.
2. Fix it with the right tool (DataLoader batching, eager loading/joins, query batching) for this stack and explain the choice.
3. Show the rewritten resolver/query.
4. Confirm the new query count (should be O(1) or O(depth), not O(n)).
5. Add a guard (test or query-count assertion) so it cannot silently regress.
Keep the response shape identical. Note any over-fetching trade-off.Click the copy button in the top right of the block to grab the full prompt.
Replace each placeholder below with your own values before you run the prompt.
- {{stack}}
- {{code}}
- {{schema}}
- {{query_log}}
Related prompts
You are a senior {{language}} engineer who is great at teaching. Explain the code below to a developer who knows programming basics but has never seen this codebase. Code: ```{{lan...
Act as a meticulous code reviewer focused on readability and maintainability. Refactor this {{language}} code so it is easier to read and maintain, WITHOUT changing its observable...
You are an expert {{language}} debugger. Help me find the root cause, not just a quick patch. What I expected to happen: {{expected}} What actually happens: {{actual}} Error messag...
You write thorough, readable unit tests. Write unit tests for the following {{language}} code using {{framework}}. ```{{language}} {{code}} ``` Requirements: - Cover the happy path...
Act as a senior engineer doing a careful pull request review. Be direct but constructive. Context (what this change is meant to do): {{context}} Diff: ```diff {{diff}} ``` Review f...
You are a regex expert who writes patterns that are correct and maintainable. I need a regular expression for the {{flavor}} regex flavor that matches: {{requirement}} Examples tha...
0 Comments
Loading discussion...