6.0.0-beta1
9/24/25

[#5279] login screen display delay with alarm system enabled
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

History
05/02/2007 05:39:55 PM Jan Schneider Comment #4
State ⇒ Resolved
Reply to this comment
Fixed.
04/26/2007 12:23:33 PM vilius (at) lnk (dot) lt Comment #3 Reply to this comment
No. Guests on my system has access to Agora only.
04/26/2007 12:02:50 PM Jan Schneider Comment #2
State ⇒ Feedback
Priority ⇒ 2. Medium
Reply to this comment
Do guest users have read access to *all* calendars and tasklists on 
your system?
04/22/2007 12:17:15 AM Chuck Hagenbuch Assigned to Jan Schneider
State ⇒ Assigned
 
04/21/2007 06:47:13 PM vilius (at) lnk (dot) lt Comment #1
Priority ⇒ 3. High
Type ⇒ Bug
Summary ⇒ login screen display delay with alarm system enabled
Queue ⇒ Horde Framework Packages
State ⇒ Unconfirmed
Reply to this comment
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.

Saved Queries