• The plugin, to select comments date, uses the “comment_date” field. But in WordPress, only the “comment_date_gmt” is indexed by default (in the MySQL database).

    It dramatically improves the speed of the queries for big databases if the “comment_date_gmt” field (but you need to use something else than CURDATE() which uses the timezoned hour of the server, not the GMT one)

Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
  • The topic ‘Proposal for speed improvement’ is closed to new replies.