[kronolith] Reminders: listAlarms () why not a filter on event_start ?
Patrick ABIVEN
patrick.abiven at apitech.fr
Wed Oct 7 13:57:57 UTC 2009
Hello
Using Horde_Alarms for Kronolith reminders on a large database, we are facing poor performances due to the large number of events retrieved at each iteration. And many of these events doesn't occurs before weeks.
In kronolith/lib/Driver/sql.php, the listAlarms() function calls $this->listEvents($date, null, true); Instead of passing null for the second argument (use for filtering on event_start), it seems that passing $date + X days will greatly reduce the number of events. X can be defined as a configuration argument.
Thank for your advises.
Patrick
More information about the kronolith
mailing list