Investigate and reduce N+1 SQL queries when publishing multiple draft notes
Background
Based on #433461 (closed), when publishing multiple draft notes, db_count
can go up to 1421
. This is possibly because of some N+1 queries.
Proposal
Investigate if there are any N+1 queries and reduce them. If there are different queries, feel free to split them into smaller issues and add to epic.
Suggestion to use pb
is mentioned in &13041 (comment 1800978472).
Edited by Patrick Bajao