 zhenyi
|
15b875e18d
|
perf(issues): replace N+1 queries with batch operations
- Add Repo::find_by_ids() batch query using WHERE id = ANY($1)
- Replace 3 sequential validation loops (repos, labels, assignees)
with batch queries using ANY($1)
- Replace 3 sequential INSERT loops with single INSERT...SELECT
FROM unnest() statements
- Extract 7 helper methods: validate_issue_repos,
validate_issue_labels, validate_issue_assignees,
validate_issue_milestone, insert_issue_repo_relations,
insert_issue_label_relations, insert_issue_assignees
- Reduce issue_create() from ~243 lines to ~80 lines
|
2026-06-10 18:49:00 +08:00 |
|