Closed emrikol closed 4 years ago
On sites that have millions of posts in their wp_posts table, the old query can take A VERY LONG TIME.
Switching it to this, and just returning the year from SQL speeds it up. In my testing, this can be up to 500% faster.
On sites that have millions of posts in their wp_posts table, the old query can take A VERY LONG TIME.
Switching it to this, and just returning the year from SQL speeds it up. In my testing, this can be up to 500% faster.