Make WordPress Core

Opened 2 years ago

Last modified 2 years ago

#54555 new defect (bug)

Slow media query on big sites

Reported by: lebada's profile lebada Owned by:
Milestone: Awaiting Review Priority: normal
Severity: normal Version: 5.8.2
Component: Media Keywords:
Focuses: performance Cc:

Description

On wordpress version 5.8.2 the wp_enqueue_media() slow query is still there. I found several old discussions about being fixed for many years ago but in my case is still there.

SELECT DISTINCT YEAR( post_date ) AS year, MONTH( post_date ) AS month
FROM wp_posts
WHERE post_type = 'attachment'
ORDER BY post_date DESC

4.6238s

I have 73903 media items

Change History (1)

#1 @sabernhardt
2 years ago

  • Component changed from General to Media
Note: See TracTickets for help on using tickets.