Reducing database queries

Using transients for each department didn’t seem to help much.

There are about 220 posts of the faculty_profile post type.

We’ll be using WP Super Cache, so there won’t necessarily be 700 db queries for each page load. But, I’d still like to improve this.

Here’s the code, which was removed by a moderator.

https://wordpress.pastebin.com/jZX7Ev3k

Thanks for your help.

That’s tough…

I recommend something like w3_total_cache with memcache or even better APC installed. w3tc will not only give you page caching, but will give you object caching so that your queries won’t hit the database most of the time the are called on a variant of your page that has not yet been loaded.

Simple page caching would still cause those pages to be processed when someone is logged in and hits that page or perhaps after a comment has been left. So you want an object cache to keep the results of the query executions in memory too.

Thanks Brian. I will give w3_total_cache a try.

We have experimented with WP Super Cache’s “Directly Cached Files” features and this works, even if it is a little more brute force than we’d like.

I was hoping I was simply missing some obvious techniques to reduce the number of queries!