Forum Replies Created
-
AuthorPosts
-
June 15, 2017 at 3:17 am in reply to: query performance issues on update_meta with new meta chunker #1298374NicolasParticipant
This reply is private.
June 14, 2017 at 11:48 pm in reply to: query performance issues on update_meta with new meta chunker #1298307NicolasParticipantDear 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
NicolasParticipantThis reply is private.
NicolasParticipantThe last release did not fix the issue : it takes about one minute to publish a single event. Please, could you provide me an help ?
NicolasParticipantPlease Shelby, I need an answer : should it work if I revert to 4.4 or even 4.3 versions ?
NicolasParticipantThe last release did not fix anything…
NicolasParticipantDear Shelby,
Should The Events Calendar 4.6.0 Release Candidate 2 be able to fix this problem ?
Best Regards,
Nicolas
NicolasParticipantHello,
Bulk Delete plugin deletes all kind of posts but ignored
Regard,
-
AuthorPosts