Slow SQL queries for the NPM metadata endpoint
🔥 Problem
NPM package's metadata endpoint GET /api/:version/packages/npm/:package_name"
has some slow SQL queries link (internal) that directly effect the error budget.
🚒 Solution
The plan is to have two MRs:
- MR1. Add index to the database to speed up existing queries: #388241 (comment 1253617716)
- MR2. Improve existing query: #388241 (comment 1255746638)
Edited by Tim Rizzi