Summary | login screen display delay with alarm system enabled |
Queue | Horde Framework Packages |
Queue Version | HEAD |
Type | Bug |
State | Resolved |
Priority | 2. Medium |
Owners | jan (at) horde (dot) org |
Requester | vilius (at) lnk (dot) lt |
Created | 04/21/2007 (6731 days ago) |
Due | |
Updated | 05/02/2007 (6720 days ago) |
Assigned | 04/26/2007 (6726 days ago) |
Resolved | 05/02/2007 (6720 days ago) |
Github Issue Link | |
Github Pull Request | |
Milestone | |
Patch | No |
State ⇒ Resolved
State ⇒ Feedback
Priority ⇒ 2. Medium
your system?
State ⇒ Assigned
Priority ⇒ 3. High
Type ⇒ Bug
Summary ⇒ login screen display delay with alarm system enabled
Queue ⇒ Horde Framework Packages
State ⇒ Unconfirmed
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.