Events Calender makes my website slow!?

[Jakob Holmberg]

I have a major problem with Events Calender Pro on my site. It fills the option database with a lot of info…
My options database is now about 450 Mb and seems to log avery search in our calendar…

This makes the site terrible slow. What can I do?

[George]

Hey Jakob,

I’m really sorry to hear about this!

1. What specifically do you mean when you say that the options table “seems to log avery search in our calendar”? What does this mean, specifically?

2. How are you hosting your website? Are you hosting it on your own server? Are you using a webhost online? If so, which one? Share a link to the website where you buy your hosting from.

3. Can you share your site’s “System information” with us? This will help us investigate. Here’s how to share that information → https://theeventscalendar.com/knowledgebase/sharing-sys-info/

Thank you!
George

[Jakob Holmberg]

I will try to answer… My site is http://pingstjonkoping.se

1. I dont know what is logs, but the options database is so big, and i found A LOT of threads with “tribe-events-xx” in it. I attach two excerpts from that database so you can see what it contains. I just made a random pick.
File 1: https://dl.dropboxusercontent.com/u/14200118/Options_database_id342.pdf
File 2: https://dl.dropboxusercontent.com/u/14200118/Options_database_id380.pdf

2. I use one of the biggest web hosting service in Sweden, http://www.loopia.com and using the hosting service called “Business”.

3. Here follows my system information:

URL

Start

INSTALL KEYS
events-calendar-pro = afe7d46f656da2c3e3038719145a0ea4d43d5c43
WORDPRESS VERSION
4.4.2
PHP VERSION
5.5.32
PLUGINS
Advanced Custom Fields version 4.4.5 by Elliot Condon(http://www.elliotcondon.com/)
Advanced Post Manager version 4.0 by Modern Tribe, Inc.(http://m.tri.be/4n)
Akismet version 3.1.7 by Automattic(http://automattic.com/wordpress-plugins/)
All In One WP Security version 4.0.5 by Tips and Tricks HQ, Peter, Ruhul, Ivy(http://www.tipsandtricks-hq.com/)
Contact Form DB version 2.9.16 by Michael Simpson
Contact Form 7 version 4.4 by Takayuki Miyoshi(http://ideasilo.wordpress.com/)
Display Posts Shortcode version 2.5.1 by Bill Erickson(http://www.billerickson.net)
Display Team version 2.4 by Simon Sandgre(http://www.billerickson.net)
The Events Calendar PRO version 4.0.6 by Modern Tribe, Inc.(http://m.tri.be/20)
WPBakery Visual Composer version 4.5.2 by Michael M – WPBakery.com(http://wpbakery.com)
More Taxonomies version 1.1 by Henrik Melin, Kal Ström(http://labs.dagensskiva.com/)
More Types version 1.2 by Henrik Melin, Kal Ström(http://labs.dagensskiva.com/)
P3 (Plugin Performance Profiler) version 1.5.3.9 by GoDaddy.com(http://www.godaddy.com/)
Page-list version 5.1 by webvitaly(http://web-profile.com.ua/wordpress/plugins/)
Redirection version 2.4.3 by John Godley(http://urbangiraffe.com)
Revolution Slider version 4.6.93 by ThemePunch(http://themepunch.com)
The Events Calendar version 4.0.6 by Modern Tribe, Inc.(http://m.tri.be/1x)
UpdraftPlus – Backup/Restore version 1.11.27 by UpdraftPlus.Com, DavidAnderson(https://updraftplus.com)
Widget Logic version 0.57 by Alan Trewartha(http://freakytrigger.co.uk/author/alan/)
WP Super Cache version 1.4.7 by Automattic(https://automattic.com/)
Visningsbild (avatar) version 2.0.6 by flippercode(http://www.flippercode.com/)
NETWORK PLUGINS
–
MU PLUGINS
p3-profiler.php
THEME
the7dtchild
MULTISITE
–
SETTINGS
recurring_events_are_hidden = exposed
tribeEventsTemplate =
tribeEventsBeforeHTML =
tribeEventsAfterHTML =
previous_ecp_versions = Array
(
[0] => 0
[1] => 3.3.1
[2] => 3.4.1
[3] => 3.10.1
[4] => 3.11
[5] => 3.11.2
[6] => 3.12.2
[7] => 3.12.3
[8] => 3.12.5
[9] => 3.12.6
[10] => 4.0
[11] => 4.0.5
)
latest_ecp_version = 4.0.6
welcome_notice = 1
defaultValueReplace =
disable_metabox_custom_fields = hide
custom-fields = Array
(
[0] => Array
(
[name] => _ecp_custom_1
[label] => Predikan
[type] => text
[values] =>
)
[1] => Array
(
[name] => _ecp_custom_2
[label] => Musik
[type] => text
[values] =>
)

)

viewOption = month
donate-link =
postsPerPage = 10
liveFiltersUpdate =
hideSubsequentRecurrencesDefault =
userToggleSubsequentRecurrences =
recurrenceMaxMonthsBefore = 24
recurrenceMaxMonthsAfter = 12
showComments =
showEventsInMainLoop =
eventsSlug = kalender
singleEventSlug = kalender
multiDayCutoff = 00:00
defaultCurrencySymbol = kr
reverseCurrencyPosition = 1
embedGoogleMaps =
geoloc_default_geofence = 25
geoloc_default_unit = kms
embedGoogleMapsZoom = 15
debugEvents =
stylesheetOption = full
tribeEnableViews = Array
(
[0] => list
[1] => month
[2] => week
)
tribeDisableTribeBar = 1
hideLocationSearch = 1
hideRelatedEvents = 1
monthEventAmount = 7
eventsDefaultOrganizerID = 171
eventsDefaultVenueID = 54
eventsDefaultAddress =
eventsDefaultCity =
eventsDefaultState =
eventsDefaultProvince =
eventsDefaultZip =
defaultCountry =
eventsDefaultPhone =
tribeEventsCountries =
schema-version = 4.0.6
last-update-message = 4.0.5
pro-schema-version = 4.0.6
latest_date = 2016-12-18 13:00:00
week_view_hide_weekends =
enable_month_view_cache = 1
dateWithYearFormat = j F, Y
dateWithoutYearFormat = j F
monthAndYearFormat = F Y
weekDayFormat = D jS
dateTimeSeparator = kl.
timeRangeSeparator = –
datepickerFormat = 0
organizer_venue_amalgamation = 1
WORDPRESS TIMEZONE
Europe/Stockholm
SERVER TIMEZONE
UTC
COMMON LIBRARY DIR
/www/webvol17/8b/5obl55bou5as8yq/pingstjonkoping.se/public_html/wp-content/plugins/the-events-calendar/common/src/Tribe
COMMON LIBRARY VERSION
4.0.6

[George]

Thank you for this information, @Jakob!

The HTML in the wp_options table in your screenshots seems to be there because of the “Month View Cache” option in our plugin, which I see is enabled in your system information.

I would recommend heading to Events > Settings in your wp-admin and un-checking this option:

Then, if possible I would recommend deleting the transient option that all of that HTML is associated with. This is doable with a SQL command, though if you’re not familiar with this, you should contact your webhost support and ask them to delete the transient option that is shown in the screenshots you shared.

You should also ask them if they have thoughts about your site performance; they may be able to pinpoint the issue, as the HTML in the options table may not be the actual problem.

Let me know what you find by doing the sorts of things I mention here.

Thank you Jakob!

– George

[Support Droid]

This topic has not been active for quite some time and will now be closed.

If you still need assistance please simply open a new topic (linking to this one if necessary)
and one of the team will be only too happy to help.

[Geoff]

Hey there,

Just want to drop a quick note in here to let you know that The Events Calendar 4.2.1 is about to release any moment and it will include a patch for this issue. Please update and let us know if you continue to hit any trouble.

Thanks so much for your patience while we worked on this!

Cheers,
Geoff

[Author]

Posts