/wp-admin/post.php is so slow because of wrong query

[wolfkang]

I have 28,732 rows in the wp_posts table, and 1,631,109 rows in the wp_postmeta.

The post edit page is so slow and its loading time is over 7 seconds.

/wp-admin/includes/template.php shoud be modified like this.

Before modification in line 673

        $sql = "SELECT meta_key
                FROM $wpdb->postmeta
                GROUP BY meta_key
                HAVING meta_key NOT LIKE %s
                ORDER BY meta_key
                LIMIT %d";

After modification

        $sql = "SELECT DISTINCT meta_key
                FROM $wpdb->postmeta
                WHERE meta_key NOT LIKE %s
                ORDER BY meta_key
                LIMIT %d";

The grouping is not necessary.

Please check it out.

[johnbillion]

Thanks for the report wolfkang!

This is a duplicate of an existing issue: #24498.