TEC Slowing WP-Admin

Resolved manfromnapa
(@manfromnapa)

3 years ago

Since installing TEC my wp-admin has been slow. I installed Query Monitor to see what the issue is. It reports:

DESCRIBE wp_tec_events;
TEC\E\C\V\S\Abstract_Custom_Table->update()
Plugin: the-events-calendar
Rows: 10
Time: 0.0696

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’
TEC\E\C\V\S\Abstract_Custom_Table->get_schema_constraint()
Plugin: the-events-calendar
Rows: 0
Time: 8.9343

I’m using TEC version 2.5.6, PHP Version 8.1, WordPress 6.1.1

What could be causing this slowdown?

Viewing 15 replies - 1 through 15 (of 21 total)

1 2 →

Plugin Author Sam
(@sdokus)

3 years ago

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.

Thread Starter manfromnapa
(@manfromnapa)

3 years ago

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

Plugin Support Darian
(@d0153)

3 years ago

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?

Thread Starter manfromnapa
(@manfromnapa)

3 years ago

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

Plugin Support Darian
(@d0153)

3 years ago

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)?

Thread Starter manfromnapa
(@manfromnapa)

3 years ago

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

Plugin Support Darian
(@d0153)

2 years, 12 months ago

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.

Thread Starter manfromnapa
(@manfromnapa)

2 years, 11 months ago

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

Plugin Support Darian
(@d0153)

2 years, 11 months ago

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 WordPress.org support guidelines.

Thread Starter manfromnapa
(@manfromnapa)

2 years, 11 months ago

Thank you.
Plugin Support Darian
(@d0153)

2 years, 11 months ago
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.
Thread Starter manfromnapa
(@manfromnapa)

2 years, 11 months ago

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

Plugin Support Darian
(@d0153)

2 years, 11 months ago

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://wordpress.org/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.

Plugin Support Darian
(@d0153)

2 years, 11 months ago

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?

Thread Starter manfromnapa
(@manfromnapa)

2 years, 11 months ago

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://wordpress.org/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.

Viewing 15 replies - 1 through 15 (of 21 total)

1 2 →

The topic ‘TEC Slowing WP-Admin’ is closed to new replies.