ALL THE VENUE POSTS stored in post_meta DB are update_meta_cached

[Nicolas]

Good evening,

When a single event is published or updated, ALL THE VENUE POSTS stored in post_meta DB are update_meta_cached !

// Get meta info
$id_list = join(‘,’, $ids);
$cache = array();
$meta_list = $wpdb->get_results( $wpdb->prepare(“SELECT $column, meta_key, meta_value FROM $table WHERE $column IN ($id_list)”,
$meta_type), ARRAY_A );
$id_list = ALL VENUE IDs are included !!!

Result –> LONG AND SLOW QUERY

Two solutions :
1. Trash all venue posts (sniff…)
2. Prevent publish or save to update venue posts

Could you help me shiftly please to prevent venues’ update thanks to a snippet please ?

Best,

Nicolas

[Nicolas]

This reply is private.

[Victor]

Closing this as it’s a duplicate of this other thread > https://theeventscalendar.com/support/forums/topic/query-performance-issues-on-update_meta-with-new-meta-chunker/

[Author]

Posts