[wp-trac] [WordPress Trac] #58368: WordPress dashboard is very slow when there are many comments (and the database isn't great)
WordPress Trac
noreply at wordpress.org
Mon Jun 19 07:17:36 UTC 2023
#58368: WordPress dashboard is very slow when there are many comments (and the
database isn't great)
--------------------------------------+--------------------------
Reporter: Guss77 | Owner: (none)
Type: defect (bug) | Status: new
Priority: normal | Milestone: 6.3
Component: Comments | Version: 6.2.2
Severity: minor | Resolution:
Keywords: has-patch has-unit-tests | Focuses: performance
--------------------------------------+--------------------------
Comment (by FolioVision):
Replying to [comment:25 spacedmonkey]:
> I think the biggest issue here is that comment_type does not have an
index.
In our testing just adding the index did not always solve the issue of the
slow Comment Type drop down. It helped on a website with a **dedicated**
MariaDB database server, but on a **shared** web host we also had to stop
using `ORDER BY` to improve the performance.
Full details in our related ticket: #58488
--
Ticket URL: <https://core.trac.wordpress.org/ticket/58368#comment:27>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform
More information about the wp-trac
mailing list