Forum Replies Created
-
AuthorPosts
-
June 15, 2017 at 3:17 am in reply to: query performance issues on update_meta with new meta chunker #1298374
Nicolas
ParticipantThis reply is private.
June 14, 2017 at 11:48 pm in reply to: query performance issues on update_meta with new meta chunker #1298307Nicolas
ParticipantDear Victor,
Thank you for your kind availability.
We use this snippet since yesterday. It perfectly resolved the issue but only with regular post and not custom ones.
The issue appeared when you introduced a new class named meta_chunker.
Actually, to publish an event (and before this snippet a regular post as well) is activating wp-include/meta :
// 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 );This update causes a very long query witch hits the DB (a bunch of hundreds of ID is included inside). This burns a large amount of memory and slow down the database.
So, is there a way to bypass chunker waiting next release ? For instance :
function tribe_remove_post_from_chunker( $post_types ) {
return array_diff( $post_types, array( ‘post’, ‘tribe_events’, ‘tribe_categorie’, ‘tribe_venue’, tribe_meta’ ) );
}
add_filter( ‘tribe_meta_chunker_post_types’, ‘tribe_remove_post_from_chunker’ );Thank you for your urgent and appreciate help.
Best regards,
Nicolas
Nicolas
ParticipantThis reply is private.
Nicolas
ParticipantThe last release did not fix the issue : it takes about one minute to publish a single event. Please, could you provide me an help ?
Nicolas
ParticipantPlease Shelby, I need an answer : should it work if I revert to 4.4 or even 4.3 versions ?
Nicolas
ParticipantThe last release did not fix anything…
Nicolas
ParticipantDear Shelby,
Should The Events Calendar 4.6.0 Release Candidate 2 be able to fix this problem ?
Best Regards,
Nicolas
Nicolas
ParticipantHello,
Bulk Delete plugin deletes all kind of posts but ignored
Regard,
-
AuthorPosts
