[Tickets #5279] login screen display delay with alarm system enabled

[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=5279
-----------------------------------------------------------------------
 Ticket             | 5279
 Created By         | vilius at lnk.lt
 Summary            | login screen display delay with alarm system enabled
 Queue              | Horde Framework Packages
 Version            | HEAD
 Type               | Bug
 State              | Unconfirmed
 Priority           | 3. High
 Owners             | 
-----------------------------------------------------------------------


vilius at lnk.lt (2007-04-21 11:47) wrote:

After introduction of unified Alarm system into HEAD I see a big memory hog
and ~5 second delay trying to view login window. This happens because Horde
is trying to list all events for guest user from all users on the system.
Queries:

Mar 29 23:59:55 HORDE [debug] [kronolith] SQL event list by : query =
"SELECT event_id, event_uid, event_description, event_location,
event_private, event_st
atus, event_attendees, event_keywords, event_title, event_category,
event_recurcount, event_recurtype, event_recurenddate,
event_recurinterval, event_recurda
ys, event_start, event_end, event_alarm, event_modified, event_exceptions,
event_creator_id FROM kronolith_events WHERE calendar_id = ? AND
((event_alarm > ?
)) AND ((event_end > ? AND event_start < ?) OR (event_recurenddate >= ?
AND event_start <= ? AND event_recurtype <> ?))" [on line 302 of
"/var/www/html/horde
/kronolith/lib/Driver/sql.php"]

and

Mar 29 23:59:55 HORDE [debug] [nag] SQL alarms list by : table =
nag_tasks; query = "SELECT * FROM nag_tasks WHERE task_owner = ? AND
task_alarm > 0 AND (tas
k_due - (task_alarm * 60) <= ?) AND task_completed = 0" [on line 419 of
"/var/www/html/horde/nag/lib/Driver/sql.php"]

are performed exactly 230 times (<-- number of users on my system). This
is very bad and can lead to horrible performance on big installations.