Make WordPress Core

Opened 8 months ago

#59488 new enhancement

Add index to comment_type and comment_approved fields in comment table

Reported by: spacedmonkey's profile spacedmonkey Owned by:
Milestone: Awaiting Review Priority: normal
Severity: normal Version: 3.0
Component: Comments Keywords:
Focuses: performance Cc:

Description

Follow on from #58368

It is common to query comments by comment_type or comment_approved. There are several query done in the admin to get counts for different screens. But for sites with many comments, this results in slow returning queries. Add database indexes to these two fields to improve database performance.

Change History (0)

Note: See TracTickets for help on using tickets.