Greg Ichneumon Brown

We use Elasticsearch on a lot of WordPress.com VIP sites when they are not performing well. Mostly using https://github.com/alleyinteractive/es-wp-query It depends a bit on exactly which queries are not performing well for you though.

ElasticPress is probably a good option for offloading slow posts queries: https://www.ads-software.com/plugins/elasticpress/ There is a hosted version of it also: https://www.elasticpress.io/

If your problem is search specific, you can also look at the Pro plan on Jetpack to get access to the search beta: https://jetpack.com/support/search/

Hi MultiformeIngegno,

Unfortunately there is a not a spectacular way to do this mostly because it could significantly slow down your page load time.

The function you see there does get the top posts for display in the admin by downloading a csv of our stats from wordpress.com:

https://plugins.trac.www.ads-software.com/browser/jetpack/trunk/modules/stats.php#L955

Getting that csv can take quite a while, and the more traffic you have, the longer it will take. So doing this for every page load would not be something I would recommend unless you have some good local caching of the data and are only loading it once a day or so.

You could certainly reuse some of the above code to be able to do that, and could probably get it to work. But you should be careful in doing so. ??

Hope that helps.

Hi @billbennett,

Thanks for noticing this. A recent change to Site Stats that shouldn’t have gone out to Jetpack users leaked through. Sorry about that. Fixed now.