Skip to content
Snippets Groups Projects

codeintel: use COUNT OVER() window function for getting uploads/indexes total count

Merged Warren Gifford requested to merge nsc/get-with-count-sql into main

Created by: Strum355

May or may not close #34915 (closed) by implementing the approach from the linked stackoverflow issue. Performance improvements weren't stable (sometimes faster, sometimes on-par), so I want to observe this in production for a while to see how the average case does, given we're only having to make one query here instead of two, the overhead saved may work in its favour.

Test plan

Covered by existing tests and dashboards

Merge request reports

Merged by avatar (Jun 8, 2025 5:41pm UTC)

Loading

Activity

Filter activity
  • Approvals
  • Assignees & reviewers
  • Comments (from bots)
  • Comments (from users)
  • Commits & branches
  • Edits
  • Labels
  • Lock status
  • Mentions
  • Merge request status
  • Tracking
Please register or sign in to reply
Loading