Skip to content

Optimize SQL queries #14332

Description

@TobyCyan

Several actions in the action layer invoke logic-layer methods inside loops, which in many cases lead to N + 1 query/call patterns.

We should identify these N + 1 call sites and replace them with batched SQL queries.

If possible, provide a proof of improvement (e.g. benchmark results)

Metadata

Metadata

Assignees

No one assigned

    Labels

    core team onlyNot open for external contributions

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions