General discussion on installation and configuration of SOGo

Text archives Help


Re: [SOGo] ics export is slow


Chronological Thread 
  • From: Christian Mack < >
  • To:
  • Subject: Re: [SOGo] ics export is slow
  • Date: Thu, 06 Aug 2015 09:59:41 +0200

Am 30.06.2015 um 09:20 schrieb Emmanuel Dreyfus:
> Hi
>
> I posted already about this issue and got no reply. I repost as I gathered
> more information.
>
> Exporting as .ucs is painfully slow. It can take more than 30s. I ruled
> out any problem with Apache and MySQL:
>
> 1) No problem in Apache, as the problem happens if I ask SOGo directly:
> $ ICS="/SOGo/dav/user/Calendar/3E8-50B38880-F-6B8B4580.ics"
> $ time wget http://sogo-anonymous:@localhost:20000${ICS}
> Resolving localhost (localhost)... ::1, 127.0.0.1
> Connecting to localhost (localhost)|::1|:20000... failed: Connection
> refused.
> Connecting to localhost (localhost)|127.0.0.1|:20000... connected.
> HTTP request sent, awaiting response... 401 Authorization Required
> Authentication selected: basic realm="SOGo"
> Connecting to localhost (localhost)|127.0.0.1|:20000... connected.
> HTTP request sent, awaiting response... 200 OK
> Length: 1014850 (991K) [text/calendar]
> Saving to: '3E8-50B38880-F-6B8B4580.ics.3'
>
> 3E8-50B38880-F-6B8B 100%[=====================>] 991.06K --.-KB/s in
> 0.05s
>
> 2015-06-30 09:11:15 (19.9 MB/s) - '3E8-50B38880-F-6B8B4580.ics.3' saved
> [1014850/1014850]
>
> 50.48s real 0.00s user 0.04s system
>
> 2) No problem with MySQL. I enabled the slow query log, and mysqldumpslow
> tells me no query took more than 0.25s. Therefore adding an index will not
> help.
>
> Count: 1 Time=0.25s (0s) Lock=0.00s (0s) Rows=1559.0 (1559)
> SELECT b.c_name,b.c_version,b.c_lastmodified,b.c_creationdate,
> a.c_component,b.c_content
> FROM sogouser00636dbde13_quick a, sogouser00636dbde13 b WHERE
> (c_classification = N) AND a.c_name = b.c_name AND (c_deleted !=
> N OR c_deleted IS NULL)
>
> Count: 1 Time=0.03s (0s) Lock=0.00s (0s) Rows=1803.0 (1803),
> SELECT c_lastmodified FROM sogouser00636dbde13 ORDER BY c_lastmodified
> DESC
>
> Count: 6 Time=0.00s (0s) Lock=0.00s (0s) Rows=1.0 (6),
> SELECT c_folder_id, c_path, c_location, c_quick_location,
> c_acl_location, c_folder_type FROM sogo_folder_info WHERE c_path1
> = 'S' AND c_path2 = 'S' AND c_path3 = 'S' AND c_path4 = 'S'
>
> Count: 5 Time=0.00s (0s) Lock=0.00s (0s) Rows=3.0 (15),
> SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'S' AND
> c_folder_type = 'S'
>
> Count: 1 Time=0.00s (0s) Lock=0.00s (0s) Rows=1.0 (1),
> SELECT c_uid, c_object, c_role FROM sogoedreyfus0011f18833d_acl
> WHERE (c_object = 'S') AND ((c_uid = 'S') OR (c_uid LIKE 'S'))
>
>
> Therefore the problem is really inside SOGo. Peeking at the source,
> it is said that SOGo has to parse the .ics output from the database.
> Could that be the problem? Is there a way to speed it up?
>

How many events are in this calendar?


Kind regards,
Christian Mack

--
Christian Mack
Universität Konstanz
Kommunikations-, Informations-, Medienzentrum (KIM)
Abteilung Basisdienste
78457 Konstanz
+49 7531 88-4416

Attachment: smime.p7s
Description: S/MIME Cryptographic Signature




Archive powered by MHonArc 2.6.18.

Top of page