TEC Slowing WP-Admin

Hi there!

Thanks for writing in with your question, sorry to hear that you’ve been experiencing some trouble with slow wp-admin times.

The first thing I noticed is that you’re using TEC version 2.5.6 – the most updated version is 6.0.10 – if there’s a reason that you can’t migrate your events to the new 6.0 database, upgrading to version 5.+ could still help.

Here’s more information about migrating to the 6.0 update: https://theeventscalendar.com/knowledgebase/k/migrating/

Additionally, we are still working to improve our compatibility with PHP 8.1 – you could try rolling back to PHP 7.4 or PHP 8.0 to see if that improves things for you.

Sorry… 2.5.6. is the version of TEC Shortcode. We were already on version 6.X, and I just upgraded to 6.0.11.

I’ve optimized our DB tables. I’m using MySQL InnoDB for all TEC tables.

We have 107 events.

As I investigate furthur I’m seeing 3 PHP Errors (All 3 are Deprecated):

Optional parameter $download_url declared before required parameter $js_action is implicitly treated as a required parameter 1
wp-content/plugins/the-events-calendar/common/vendor/vendor-prefixed/stellarwp/installer/src/Installer/Handler/Plugin.php:123
Plugin: the-events-calendar

Deprecated Optional parameter $did_action declared before required parameter $js_action is implicitly treated as a required parameter 1
wp-content/plugins/the-events-calendar/common/vendor/vendor-prefixed/stellarwp/installer/src/Installer/Handler/Plugin.php:0
Plugin: the-events-calendar

Constant FILTER_SANITIZE_STRING is deprecated 3
wp-content/plugins/the-events-calendar/common/src/functions/utils.php:1130
Plugin: the-events-calendar

Hi @manfromnapa

Thanks for your message, and for providing additional information.

The PHP error could be related to your PHP version. Were you able to downgrade your PHP version to 8.0?

8.0 resolved the deprecated results. I still get a slow query. This could be multiple things though. I’ll keep testing.

Query
SELECT?*
FROM?INFORMATION_SCHEMA.key_column_usage
WHERE?referenced_table_schema =?DATABASE()
AND?referenced_table_name?IS?NOT?NULL
AND?COLUMN_NAME= ‘event_id’
AND?TABLE_NAME = ‘wp_tec_occurrences’

Caller:
TEC\E\C\V\S\Abstract_Custom_Table->get_schema_constraint()wp-content/plugins/the-events-calendar/src/Events/Custom_Tables/V1/Schema_Builder/Abstract_Custom_Table.php:182TEC\E\C\V\S\Abstract_Custom_Table->has_constraint()wp-content/plugins/the-events-calendar/src/Events/Custom_Tables/V1/Schema_Builder/Abstract_Custom_Table.php:155TEC\E\C\V\T\Occurrences->after_update()wp-content/plugins/the-events-calendar/src/Events/Custom_Tables/V1/Tables/Occurrences.php:97TEC\E\C\V\S\Abstract_Custom_Table->update()wp-content/plugins/the-events-calendar/src/Events/Custom_Tables/V1/Schema_Builder/Abstract_Custom_Table.php:60TEC\E\C\V\S\Schema_Builder->up()wp-content/plugins/the-events-calendar/src/Events/Custom_Tables/V1/Schema_Builder/Schema_Builder.php:259TEC\E\C\V\Activation::init()wp-content/plugins/the-events-calendar/src/Events/Custom_Tables/V1/Activation.php:106do_action(‘init’)wp-includes/plugin.php:517

Component:
Plugin: the-events-calendar

Rows
0

Time
2.3864

Hi @manfromnapa

Since installing TEC my wp-admin has been slow.

I would like to follow up on this, is it still slow even if you’re not viewing the TEC related pages? Or are you only experiencing the issue on the events page (/wp-admin/edit.php?post_type=tribe_events)?

I am experiencing this slowness and this slow query on all of the WP-Admin pages. Not just TEC related ones.

Hi @manfromnapa

Thanks for your response.

Could you check your WP Memory usage with?this plugin? If the usage percentage is over 75%, consider upping your site’s WP Memory limit.

Looking forward to your reply.

PHP Version: 8.0.28 / 64Bit OS / Max execution time: 600sec
Memory limits: WordPress 256MB / PHP 256MB
Current Memory usage: 115MB

Hi @manfromnapa

Thanks for your response and for providing additional details.

Let me share this with the team, and I’ll update you once I know more.

In the meantime, if you do have other concerns or issues you need help with, please create another support topic as indicated in the www.ads-software.com support guidelines.

Thank you.

Hi @manfromnapa

Thanks for patiently waiting. Could you try adding this snippet code through the Code Snippets plugin, set to “Only run once” and check if that helps?

$future_timestamp = time() + (30 * 24 * 60 * 60); // 30 days in future
set_transient( 'tec_custom_tables_v1_initialized', $future_timestamp , DAY_IN_SECONDS );

Let me know how it goes.

I ran it. It didn’t seem to change anything.

Hi @manfromnapa

Thanks for your response. To help us narrow down the performance issue, we would need a full WP Query Monitor report.

Moreover, one of my colleagues also recommends looking at:?https://www.ads-software.com/plugins/advanced-database-cleaner/?– this has helped optimize some things since The Events Calendar plugin does a lot of post meta queries and sometimes this can help.

Just curious, were you able to replicate this issue on a staging version of your live site? If you haven’t created one yet, could you create one and check if the performance improves where WP Query Monitor is activated and deactivated?

Let us know how it goes.

Hi @manfromnapa

I hope you are well. I wanted to follow up about the issue you encountered.

Were you able to try the suggestions provided above?

Thanks for your response. To help us narrow down the performance issue, we would need a full WP Query Monitor report.

Let me look into how I can export a report. Can you point me somewhere I can see how to do this?

Moreover, one of my colleagues also recommends looking at:?https://www.ads-software.com/plugins/advanced-database-cleaner/?– this has helped optimize some things since The Events Calendar plugin does a lot of post meta queries and sometimes this can help.

I had been using WP-Optimize for DB clean up. I deactivated it and installed Advanced Database Cleaner. It cleaned some stuff out, but no noticeable improvement.

Just curious, were you able to replicate this issue on a staging version of your live site? If you haven’t created one yet, could you create one and check if the performance improves where WP Query Monitor is activated and deactivated?

I was able to replicate on a staging site. I’ve tried disabling plugins. The issue always comes back to TEC. That is, disabling TEC makes the site faster.