Plugin performance when Jetpack Site Accelerator is on

Wordpress Plugin
1

Hello, I’ve done a lot of searching for this issue, and I see lots of conversations about it, but none I could figure out a conclusion from them.

I’m on wordpress.com, business plan. We have Jetpack Site Accelerator, with Speed up image load times on and Speed up static file load times on.

In the Patreon plugin, we have Image Locking off. We have most plugin settings off; we are using it for the login and to check sub amount to turn on some site features – nothing related to content.

When the plugin is on AND Jetpack Site Accelerator is on, load time takes an additional ~11 seconds. Using Query Monitor, it looks like there are about ~110 queries being made by patreon-connect. There are all grabbing _wp_attached_file multiple times for each post. I’m assuming each request is for each image in the srcset, but I can’t be sure.

Example, all of these are for a single post on the homepage:

"SELECT post_id, meta_value
FROM wp_137391347_postmeta
WHERE meta_key = '_wp_attached_file'
AND meta_value = '2024/05/barricade.png' /* HOSTGOESHERE/ request_id: d300450a9f8389532b2b58f2e48e7abc */"

"SELECT post_id, meta_value
FROM wp_137391347_postmeta
WHERE meta_key = '_wp_attached_file'
AND meta_value = '2024/05/barricade-768x435.png' /* HOSTGOESHERE/ request_id: d300450a9f8389532b2b58f2e48e7abc */"

"SELECT post_id, meta_value
FROM wp_137391347_postmeta
WHERE meta_key = '_wp_attached_file'
AND meta_value = '2024/05/barricade-1536x870.png' /* HOSTGOESHERE/ request_id: d300450a9f8389532b2b58f2e48e7abc */"

"SELECT post_id, meta_value
FROM wp_137391347_postmeta
WHERE meta_key = '_wp_attached_file'
AND meta_value = '2024/05/barricade-2048x1160.png' /* HOSTGOESHERE/ request_id: d300450a9f8389532b2b58f2e48e7abc */"

"SELECT post_id, meta_value
FROM wp_137391347_postmeta
WHERE meta_key = '_wp_attached_file'
AND meta_value = '2024/05/barricade-1200x680.png' /* HOSTGOESHERE/ request_id: d300450a9f8389532b2b58f2e48e7abc */"

"SELECT post_id, meta_value
FROM wp_137391347_postmeta
WHERE meta_key = '_wp_attached_file'
AND meta_value = '2024/05/barricade.png' /* HOSTGOESHERE/ request_id: d300450a9f8389532b2b58f2e48e7abc */"

(I’ve replaced the domain with “hostgoeshere”)

The issue goes away if Image Acceleration is turned off OR if the plugin is turned off. The issue cannot be replicated when the site is hosted on a WP Engine dev environment instead of the Wordpress.com staging environment.

Ideally I’d like to have the plugin on AND have image acceleration on, but not take the load time hit.

I’d appreciate any advice or direction you can give. Thanks so much.

Edited to add: spreadsheet of the queries.

2

Image locking being turned off should disable image locking functionality and avoid that. If it is not happening, there may be something off with your installation.

3

As reported, the issue happened when image locking was OFF and Jetpack accelerator was ON.

Here is the workaround:

remove_filter( 'jetpack_photon_skip_image', array( Patreon_Wordpress::$patreon_compatibility , 'jetpack_photon_skip_image' ), 99 );