Calendar's Performance

Calendar's Performance

by Eugene Dest -
Number of replies: 3
Dear Gurus,

I have performance problems with Block "Calendar":
For Each page to load (with this block) needs about 10-15 seconds. When i'm hiding this block - everything is becoming fast.
Please help! What can i do? I need to use Calendar, but it is slowing all the work!

Conf: Moodle 1.9.4 (Build: 20090128)
Server: Linux 2.6.9 / PHP 5.2.5 / MySQL 4.1.22 / memory_limit 32M

Thank you in advance!

Average of ratings: -
In reply to Eugene Dest

Re: Calendar's Performance

by Eugene Dest -
Any idea? Anybody? please
In reply to Eugene Dest

Re: Calendar's Performance

by Dakota Duff -

Try turning on some debugging options to see if there are any major problems.

Also you might check the mdl_events table. Mine has a primary key and five indexes (one with four dimensions).

In reply to Dakota Duff

Re: Calendar's Performance

by Eugene Dest -
Thanks for reply!

I have turned on Debbuging, but nothing new!

I have also turned on Performance info (perfdebug). Here is the results:

With calendar: 2.10252 secs
RAM: 15.7MB / RAM peak: 15.8MB / Included 121 files
ticks: 211 user: 107 sys: 23 cuser: 0 csys: 0
Load average: 0.20 / Record cache hit/miss ratio : 0/0

Without calendar: 1.879175 secs
RAM: 15.7MB / RAM peak: 15.8MB / Included 121 files
ticks: 218 user: 109 sys: 24 cuser: 0 csys: 0
Load average: 0.31 / Record cache hit/miss ratio : 0/0

But, sometimes I get 1.7 with calendar and 1.9 without it, so i don't really know what is the problem =(

RE: mdl_event table: It is also ok.
PRIMARY PRIMARY 0 id
mdl_even_cou_ix INDEX None courseid
mdl_even_use_ix INDEX None userid
mdl_even_tim_ix INDEX None timestart
mdl_even_tim2_ix INDEX None timeduration
mdl_even_grocouvisuse_ix INDEX None groupid/courseid/visible/userid

See Calendar-Bug.gif attached for more info.
Attachment Calendar-Bug.gif