how expensive is the summary query?
-
Hi,
just curious as to how expensive this query is?$months = $wpdb->get_results( "SELECT DISTINCT MONTH( post_date ) AS month , YEAR( post_date ) AS year, COUNT( id ) as post_count FROM $wpdb->posts WHERE post_status = 'publish' and post_date <= now( ) and post_type = 'post' GROUP BY month , year ORDER BY post_date DESC" );
Given that the result of this query will change rarely, would there be any advantage in push / pulling it from a transient, instead of re-executing it on each page load that contains the widget? Just a thought…
cheers,
Hugh
Viewing 2 replies - 1 through 2 (of 2 total)
Viewing 2 replies - 1 through 2 (of 2 total)
- The topic ‘how expensive is the summary query?’ is closed to new replies.