Currently, we load stream progresses in multiple queries for each request. Especially for admins visiting the start page, this is very inefficient.
Description
Unify the db query to accept multiple ids and return all progresses. I simulated a slow database connection by connecting to a remote database via vpn and observed the timings of the endpoint /api/progress/streams:
Motivation and Context
Currently, we load stream progresses in multiple queries for each request. Especially for admins visiting the start page, this is very inefficient.
Description
Unify the db query to accept multiple ids and return all progresses. I simulated a slow database connection by connecting to a remote database via vpn and observed the timings of the endpoint
/api/progress/streams
: