Limiting what pages WordPress queries

What does the query look like to display the 50 pages?

Caching should help at any rate if you don’t yet have it installed: https://www.ads-software.com/extend/plugins/w3-total-cache/

Thanks for the heads up on the caching. I hadn’t thought that through. After I submitted the topic though, I realized that specifically in this situation, there’s no query, it’s just a static link. It’s probably just slow because of the fact that there are over 15000 total pages that it has to go through in the db to get to the right one. Is it just a situation where with that many pages, it’s going to slowdown no matter what I do? Is there anything else that I’m possibly overlooking (other than caching) that could help?

Thanks

You can delete post revisions: https://www.mydigitallife.info/2008/07/22/how-to-delete-existing-wordpress-post-revisions-storedsaved/

There’s also plugins that do this (perhaps more safe).

Give you database a little optimization (also plugins for that).

Move to a host like wpengine.com that has a ton of optimizations in the hosting environment.