WordPress.org

Resolved net
(@krstarica)

3 months, 3 weeks ago
Ref: https://wordpress.org/support/topic/sticky-posts-issues-when-redis-cache-is-full/#post-16851128

This code:
```
wp_update_post( array( 'ID' => $post->ID, 'menu_order' => $start), false, false );
```
is rather slow when updating dozens of posts.

@tillkruess is it safe to use this code instead:
```
$wpdb->update($wpdb->posts, array( 'menu_order' => $start ), array( 'ID' => $post->ID) );
clean_post_cache($post->ID);
```

Viewing 4 replies - 1 through 4 (of 4 total)

Plugin Author Till Krüss
(@tillkruess)

3 months, 3 weeks ago

Yes, that should work, but be sure to test it with a persistent object cache enabled.

Are you able to post the redis-cli MONITOR logs for the wp_update_post() call? That way we can analyze what’s causing the slowness.

Thread Starter net
(@krstarica)

3 months, 3 weeks ago

Speed difference is 20x.

Actually the slowness has nothing to do with a object cache, it’s the same when it is enabled or disabled.

I guess some plugin is causing it, even though $fire_after_hooks parameter is set to false in wp_update_post call.

Any idea how to identify the bottleneck? Tried https://github.com/WPProfiler/core but for some reason it didn’t work properly with this Ajax call.

Plugin Author Till Krüss
(@tillkruess)

3 months, 3 weeks ago

You could use XDebug to see what’s firing when wp_update_post() is called. Or turn of plugins one by one to find the culprit.

Thread Starter net
(@krstarica)

3 months, 3 weeks ago

‘transition_post_status’ action is the cause.

Need something to measure execution of hooks in production without turning off plugins.

Also found https://derrick.blog/2020/01/15/debugging-wordpress-hooks-speed/ but it doesn’t work properly.

Viewing 4 replies - 1 through 4 (of 4 total)

You must be logged in to reply to this topic.

In: Plugins
6 replies
2 participants
Last reply from: net
Last activity: 3 months, 3 weeks ago
Status: resolved