[horde] kronolith ics share

Wed Feb 20 16:19:31 UTC 2013

  I found the problem, was the timezone.
I updated the table kronolith_events setting to null the event_timezone

Massimo Balestrieri <balestrieri at mag-data.com> ha scritto:

> Hi everyone,
> I've this problem, I share calendars with link to ics but the creation i
> very slow, it' about 1 minute for 60 event (about 1 second for event) ,
> I try to put the link directly in the browser 
>
(http://myhostserver/rpc.php/kronolith/massimo.balestrieri/xxxxxxxxxxxxxxxxxxxxxxxxx.ics)
and fof about 1 minute horde is frozen for my session, this is my log file
in debug
> mode:
>
> Feb 18 10:08:45 dmzsvr2         SELECT MAX(history_ts) FROM
> horde_histories WHERE history_action =Feb 18 10:08:45 dmzsvr2        
>   'add' AND object_uid =Feb 18 10:08:45 dmzsvr2          
> 'kronolith:4BLCEPpwXDFY7sximT9MyQ7:1512495d-4385-4fa9-8e69-ee94aa095d1Feb
> 18 10:08:45 dmzsvr2           4' [pid 16405 on line 806 of
> "/usr/share/php/Horde/Db/Adapter/Base.php"]Feb 18 10:08:45 dmzsvr2    

>   SELECT MAX(history_ts) FROM horde_histories WHERE history_action =Feb
18
> 10:08:45 dmzsvr2           'modify' AND object_uid =Feb 18 10:08:45
> dmzsvr2          
> 'kronolith:4BLCEPpwXDFY7sximT9MyQ7:1512495d-4385-4fa9-8e69-ee94aa095d1Feb
> 18 10:08:45 dmzsvr2           4' [pid 16405 on line 806 of
> "/usr/share/php/Horde/Db/Adapter/Base.php"]Feb 18 10:08:45 dmzsvr2    

>   SELECT object_id, object_name FROM `rampage_objects` WHERE
> object_nameFeb 18 10:08:45 dmzsvr2           IN
> ('1512495d-4385-4fa9-8e69-ee94aa095d14') AND type_id = 2 [pid 16405 on
> line
> 806 of "/usr/share/php/Horde/Db/Adapter/Base.php"]Feb 18 10:08:45 dmzsvr2
>         SELECT DISTINCT t.tag_id AS tag_id, tag_name FROM
> `rampage_tags` tFeb 18 10:08:45 dmzsvr2           INNER JOIN
> `rampage_tagged` tagged ON t.tag_id = tagged.tag_id ANDFeb 18 10:08:45
> dmzsvr2           tagged.object_id = 4276 [pid 16405 on line 806 of
> "/usr/share/php/Horde/Db/Adapter/Base.php"]Feb 18 10:08:45 dmzsvr2    

>   SELECT MAX(history_ts) FROM horde_histories WHERE history_action =Feb
18
> 10:08:45 dmzsvr2           'add' AND object_uid =Feb 18 10:08:45
> dmzsvr2          
> 'kronolith:4BLCEPpwXDFY7sximT9MyQ7:2be63260-d45f-42fa-bc38-c8151f82115Feb
> 18 10:08:45 dmzsvr2           e' [pid 16405 on line 806 of
> "/usr/share/php/Horde/Db/Adapter/Base.php"]Feb 18 10:08:45 dmzsvr2    

>   SELECT MAX(history_ts) FROM horde_histories WHERE history_action =Feb
18
> 10:08:45 dmzsvr2           'modify' AND object_uid =Feb 18 10:08:45
> dmzsvr2          
> 'kronolith:4BLCEPpwXDFY7sximT9MyQ7:2be63260-d45f-42fa-bc38-c8151f82115Feb
> 18 10:08:45 dmzsvr2           e' [pid 16405 on line 806 of
> "/usr/share/php/Horde/Db/Adapter/Base.php"]Feb 18 10:08:45 dmzsvr2    

>   SELECT object_id, object_name FROM `rampage_objects` WHERE
> object_nameFeb 18 10:08:45 dmzsvr2           IN
> ('2be63260-d45f-42fa-bc38-c8151f82115e') AND type_id = 2 [pid 16405 on
> line
> 806 of "/usr/share/php/Horde/Db/Adapter/Base.php"]Feb 18 10:08:45 dmzsvr2
>         SELECT DISTINCT t.tag_id AS tag_id, tag_name FROM
> `rampage_tags` tFeb 18 10:08:45 dmzsvr2           INNER JOIN
> `rampage_tagged` tagged ON t.tag_id = tagged.tag_id ANDFeb 18 10:08:45
> dmzsvr2           tagged.object_id = 4278 [pid 16405 on line 806 of
> "/usr/share/php/Horde/Db/Adapter/Base.php"]Feb 18 10:08:46 dmzsvr2    

>   SELECT MAX(history_ts) FROM horde_histories WHERE history_action =Feb
18
> 10:08:46 dmzsvr2           'add' AND object_uid =Feb 18 10:08:46
> dmzsvr2          
> 'kronolith:4BLCEPpwXDFY7sximT9MyQ7:ff87ba72-86d4-4501-b33d-17bbfc45d0bFeb
> 18 10:08:46 dmzsvr2           7' [pid 16405 on line 806 of
> "/usr/share/php/Horde/Db/Adapter/Base.php"]Feb 18 10:08:46 dmzsvr2    

>   SELECT MAX(history_ts) FROM horde_histories WHERE history_action =Feb
18
> 10:08:46 dmzsvr2           'modify' AND object_uid =Feb 18 10:08:46
> dmzsvr2          
> 'kronolith:4BLCEPpwXDFY7sximT9MyQ7:ff87ba72-86d4-4501-b33d-17bbfc45d0bFeb
> 18 10:08:46 dmzsvr2           7' [pid 16405 on line 806 of
> "/usr/share/php/Horde/Db/Adapter/Base.php"]Feb 18 10:08:46 dmzsvr2    

>   SELECT object_id, object_name FROM `rampage_objects` WHERE
> object_nameFeb 18 10:08:46 dmzsvr2           IN
> ('ff87ba72-86d4-4501-b33d-17bbfc45d0b7') AND type_id = 2 [pid 16405 on
> line
> 806 of "/usr/share/php/Horde/Db/Adapter/Base.php"]Feb 18 10:08:46 dmzsvr2
>         SELECT DISTINCT t.tag_id AS tag_id, tag_name FROM
> `rampage_tags` tFeb 18 10:08:46 dmzsvr2           INNER JOIN
> `rampage_tagged` tagged ON t.tag_id = tagged.tag_id ANDFeb 18 10:08:46
> dmzsvr2           tagged.object_id = 4279 [pid 16405 on line 806 of
> "/usr/share/php/Horde/Db/Adapter/Base.php"]Feb 18 10:08:47 dmzsvr2    

>   SELECT MAX(history_ts) FROM horde_histories WHERE history_action =Feb
18
> 10:08:47 dmzsvr2           'add' AND object_uid =Feb 18 10:08:47
> dmzsvr2          
> 'kronolith:4BLCEPpwXDFY7sximT9MyQ7:136d1010-9cc9-468a-b66b-55f3b2c0f69Feb
> 18 10:08:47 dmzsvr2           e' [pid 16405 on line 806 of
> "/usr/share/php/Horde/Db/Adapter/Base.php"]Feb 18 10:08:47 dmzsvr2    

>   SELECT MAX(history_ts) FROM horde_histories WHERE history_action =Feb
18
> 10:08:47 dmzsvr2           'modify' AND object_uid =Feb 18 10:08:47
> dmzsvr2          
> 'kronolith:4BLCEPpwXDFY7sximT9MyQ7:136d1010-9cc9-468a-b66b-55f3b2c0f69Feb
> 18 10:08:47 dmzsvr2           e' [pid 16405 on line 806 of
> "/usr/share/php/Horde/Db/Adapter/Base.php"]Feb 18 10:08:47 dmzsvr2    

>   SELECT object_id, object_name FROM `rampage_objects` WHERE
> object_nameFeb 18 10:08:47 dmzsvr2           IN
> ('136d1010-9cc9-468a-b66b-55f3b2c0f69e') AND type_id = 2 [pid 16405 on
> line
> 806 of "/usr/share/php/Horde/Db/Adapter/Base.php"]Feb 18 10:08:47 dmzsvr2
>         SELECT DISTINCT t.tag_id AS tag_id, tag_name FROM
> `rampage_tags` tFeb 18 10:08:47 dmzsvr2           INNER JOIN
> `rampage_tagged` tagged ON t.tag_id = tagged.tag_id ANDFeb 18 10:08:47
> dmzsvr2           tagged.object_id = 4280 [pid 16405 on line 806 of
> "/usr/share/php/Horde/Db/Adapter/Base.php"]Feb 18 10:08:47 dmzsvr2    

>   SELECT MAX(history_ts) FROM horde_histories WHERE history_action =Feb
18
> 10:08:47 dmzsvr2           'add' AND object_uid =Feb 18 10:08:47
> dmzsvr2          
> 'kronolith:4BLCEPpwXDFY7sximT9MyQ7:244408c3-c700-4f04-b335-29e70604ce0Feb
> 18 10:08:47 dmzsvr2           3' [pid 16405 on line 806 of
> "/usr/share/php/Horde/Db/Adapter/Base.php"]Feb 18 10:08:47 dmzsvr2    

>   SELECT MAX(history_ts) FROM horde_histories WHERE history_action =Feb
18
> 10:08:47 dmzsvr2           'modify' AND object_uid =Feb 18 10:08:47
> dmzsvr2          
> 'kronolith:4BLCEPpwXDFY7sximT9MyQ7:244408c3-c700-4f04-b335-29e70604ce0Feb
> 18 10:08:47 dmzsvr2           3' [pid 16405 on line 806 of
> "/usr/share/php/Horde/Db/Adapter/Base.php"]Feb 18 10:08:47 dmzsvr2    

>   SELECT object_id, object_name FROM `rampage_objects` WHERE
> object_nameFeb 18 10:08:47 dmzsvr2           IN
> ('244408c3-c700-4f04-b335-29e70604ce03') AND type_id = 2 [pid 16405 on
> line
> 806 of "/usr/share/php/Horde/Db/Adapter/Base.php"]Feb 18 10:08:47 dmzsvr2
>         SELECT DISTINCT t.tag_id AS tag_id, tag_name FROM
> `rampage_tags` tFeb 18 10:08:47 dmzsvr2           INNER JOIN
> `rampage_tagged` tagged ON t.tag_id = tagged.tag_id ANDFeb 18 10:08:47
> dmzsvr2           tagged.object_id = 4267 [pid 16405 on line 806 of
> "/usr/share/php/Horde/Db/Adapter/Base.php"]
> --
> Responsabile EDP
> Massimo Balestrieri
> Tel. +39 0521 525361
> Fax +39 0521 525369
> E-Mail: massimo.balestrieri at mag-data.com
> Web: www.mag-data.com[1]
>
> --
> Horde mailing list
> Frequently Asked Questions: http://horde.org/faq/To unsubscribe, mail:
> horde-unsubscribe at lists.horde.org

Link:
-----
[1] http://www.mag-data.com
-- 
Responsabile EDP
Massimo Balestrieri
Tel. +39 0521 525361
Fax +39 0521 525369
E-Mail: massimo.balestrieri at mag-data.com
Web: www.mag-data.com