[Tickets #5240] reminders.php don't send notification with many calendars

[bugs at bugs.horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/?id=5240
-----------------------------------------------------------------------
 Ticket             | 5240
 Created By         | michael.menge at zdv.uni-tuebingen.de
 Summary            | reminders.php don't send notification with many calendars
 Queue              | Kronolith
 Version            | 2.1.5
 Type               | Bug
 State              | Unconfirmed
 Priority           | 2. Medium
 Owners             | 
-----------------------------------------------------------------------


michael.menge at zdv.uni-tuebingen.de (2007-04-11 05:36) wrote:

we had the reminders.php working for oure site. At some time, thescript did
not send out
any mails. 

Setting the loglevel to debug and adding some more debug statements
showed, that 
the script could not find any calendars to monitor
kronolith-h3-2.1.5/lib/Scheduler/kronolith.php line 62

the function call 
$this->_calendars = $shares->listAllShares(); 
in line 59 causes a ugly SQL query which takes very long.

SQL Query by DataTree_sql::getAttributes(): 
SELECT datatree_id, attribute_name AS name, attribute_key AS "key", 
attribute_value AS value FROM horde_datatree_attributes WHERE datatree_id
IN (647, 49077, 5295, 15892, 72276, 55905, 58293, 561, 7103, 63809, 904,
49693,  ...
13961, 9801) [on line 993 of
"/PATHTOHORDE/horde-3.1.3/lib/Horde/DataTree/sql.php"]

the ... stand for  ~14000 more numbers,  which is aboute the number of
users we have in horde. The reminders.php takes about 8 minutes to run.
Most of oure users don't use the calendar or the reminders

We had the Problem with horde-3.1.3 and kronolith-h3-2.1.2 
and with horde-3.1.4 and kronolith-h3-2.1.5