Calendar slow due to large 'oc_clndr_repeat' table

Ask all your questions regarding OC 8.0 and 8.1 Please read the Support Forum Rules
Forum rules
The forums were migrated over to https://central.owncloud.org which is based on the forum software Discourse. The forums here is put into read-only mode starting from today.

More background information about this move and the reasoning behind it is available in this blogpost:

https://daniel.molkentin.net/2016/07/20 ... d-central/
traxdigitizer
Newbie
Posts: 5
Joined: Tue May 03, 2016 3:27 pm
ownCloud version: 8.1.6
Webserver: Apache
Database: MySQL
OS: Linux
PHP version: 5.5.47

Calendar slow due to large 'oc_clndr_repeat' table

Postby traxdigitizer » Tue May 03, 2016 3:53 pm

I'm running a Linux Debian server with ocwncloud 8.1.6 on apache/mysql/php5.5.47. I'm using 3 calendars:
- private
- business
- client-cal: this is used as a readyonly calendar. It's autmatically imported from a regularly uploaded .ICS file using https://github.com/georgehrke/cl-calendarimport. All old calendar items are deleted on import.

All calendars are synced with my iphone and ipad using native IOS caldav support, and synced with outlook using CalDav Synchronizer (https://sourceforge.net/projects/outlookcaldavsynchronizer/). Works like a charm!

However, I noticed that the webinterface has become really slow. This is caused because for some reason the 'oc_clndr_repeat' table of the database has become very big. It is 300MB in size and contains over 6.000.000 records. I'm still looking into the root cause of this problem, but I'm wondering if it is possible to remove duplicates from this table? Any suggestions? What happens when I empty this table? Will it be recreated by owncloud?

tflidd
Forum Moderator
Posts: 7159
Joined: Sat Dec 07, 2013 7:27 pm
ownCloud version: 8.2.3
Webserver: Apache
Database: MySQL
OS: Linux

Re: Calendar slow due to large 'oc_clndr_repeat' table

Postby tflidd » Wed May 04, 2016 9:20 am

The calendar app was rewritten for owncloud 9.0. So the devlopement for the old app somehow stopped. I'm not sure if bugs are still fixed at all, the bugtracker moved here: https://github.com/owncloudarchive/calendar/issues
Concerning your question if this table can be cleaned or deleted, please redirect this question directly to the developers. Use the mailinglist or IRC.


  • Similar Topics
    Replies
    Views
    Last post

Return to “ownCloud Server 8.0 and 8.1”

Who is online

Users browsing this forum: No registered users and 2 guests