Issue Summary

The time taken to load Blogpost has increased.

This is reproducible on Data Center: Yes

Steps to Reproduce

1. Install a Confluence version mentioned in the affected versions
2. Create a space with a lot of blogpost(e.g. 100 blogpost)
3. Navigate to a blogpost

Expected Results

The time to take load a blogpost is fast

Actual Results

The time taken to load a blogpost goes up to a minute or more depending on the environment

Investigation

The method PageManager.getBlogPosts() is executed several times. In the example below it was executed 96 times, and we can find 96 attempts in atlassian-confluence-sql.log

2023-05-02 10:02:24,359 [http-nio-8090-exec-12] 
[7288.2ms] - /confluence/pages/viewpage.action
...
           [12.5ms] - SpaceManager.getLogoForSpace()
           [474.6ms] - PageManager.getYearsWithBlogPosts()
           [4497.9ms] [count: 96, avg: 46.9ms] - PageManager.getBlogPosts()

The query was executed 96 times
sql-query_2023-05-02T10_07_33.346Z.txt

Observation

As it executes an SQL query several times, over time this can slow down the overall performance of the application when multiple users are accessing

Workaround

There are currently no known workaround