[horde] memory hog in HEAD

Vilius Šumskas vilius at lnk.lt
Fri Mar 30 05:48:16 UTC 2007


More info about the issue.

I swiched DEBUG level logging and this is what I see in horde.log.
Every time I try to login Horde performs two queries exactly *230
times* (<--- the number of users of my system).

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"]


-- 
Best regards,
 Vilius



More information about the horde mailing list