martin.krcho on "[Plugin: WP Smush] Long delay when loading the post editor"

ساخت وبلاگ

martin.krcho
Member
Posted 1 day ago #

The plugin introduces almost 40 second delay when I load the "Edit Post" page in the admin UI. It makes over 50 database queries similar to the one below. I used Xdebug and Query Monitor plugin to track these queries down. Each query takes just under a second.

Why is it loading so much data? Is it trying to do something that should be done as part of a cron?

SELECT main_posts.ID
FROM main_posts
LEFT JOIN main_postmeta
ON (main_posts.ID = main_postmeta.post_id
AND main_postmeta.meta_key = 'wp-smpro-smush-data' )
WHERE 1=1
AND (main_posts.post_mime_type = 'image/jpeg'
OR main_posts.post_mime_type = 'image/gif'
OR main_posts.post_mime_type = 'image/png')
AND ( main_postmeta.post_id IS NULL )
AND main_posts.post_type = 'attachment'
AND ((main_posts.post_status <> 'trash'
AND main_posts.post_status <> 'auto-draft'
AND main_posts.post_status <> 'autoresponder'))
GROUP BY main_posts.ID
ORDER BY main_posts.ID DESC
LIMIT 72000, 2000

https://wordpress.org/plugins/wp-smushit/

Umesh Kumar
Member
Plugin Author

Posted 1 day ago #

Hi @martin.krcho,

The query is for setting up the stats, so it pulls up the Meta for the images.

And yeah it shouldn't load the stats in here and slow down the Post Editor page.

I'll definitely add a fix in the upcoming release.

Thanks

Umesh Kumar
Member
Plugin Author

Posted 5 hours ago #

Hi @martin.krcho,

This should be fixed with version 2.2.2, Can you possibly give it a quick check.

Thanks

martin.krcho
Member
Posted 10 minutes ago #

Hi Umesh, I can confirm this seems to be fixed in the latest version. Thanks for the fix.

martin.krcho
Member
Posted 5 minutes ago #

Closing the ticket.

WordPress ...
ما را در سایت WordPress دنبال می کنید

برچسب : نویسنده : استخدام کار wpss بازدید : 88 تاريخ : شنبه 28 فروردين 1395 ساعت: 23:59