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

* Your Email Address
* Spam protection	Enter the letters below: .___.. .. .._..__. \| \| \|\|_/ \| [__] \| \|__\|\| \_\|_\| \|
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.
Attachment
Watch this ticket

Saved Queries