Page 1 of 1

Speed up month to month

PostPosted: Wed Jul 28, 2010 11:00 am
by kaostika
Hi,

The calendar work fast except when it is on month view. If takes about 10 seconds to switch months. I think it is the color info. Anyway to speed this up?

Oreste

PostPosted: Thu Jul 29, 2010 7:45 am
by John Sindelar
Hey Oreste,

10 seconds seems like a very long time and not at all what I'd expect.

You'll find a number of tips to speed things up here: http://www.seedcode.com/pmwiki/pmwiki.p ... ndar.Speed

PostPosted: Thu Jul 29, 2010 8:16 am
by kaostika
HI, it took 19 seconds to switch months. There are no index fields. There are about 3000 records it is looking thru. Does it prefilter before it goes to each month?

Oreste

PostPosted: Thu Jul 29, 2010 8:35 am
by kaostika
I only have one source.

PostPosted: Thu Jul 29, 2010 8:39 am
by John Sindelar
I'm not sure how you're using "pre-filter", but here is what happens on the month: the calendar finds all the records happening in that month, then does a constrain for those matching the calendar's filters, if any. Then it load these events into the $$vars that draw the calendar. As you move from month to month, the date range changes and it does this again. Thus you'll see speed changes as you navigate into less busy months.

If you're getting 9 seconds and don't have any un-indexed fields on your Source No 1 layout then you likely have too many records being displayed for the hardware / network you're using. The speed article I linked to in the past post contains strategies to deal with this, either filtering the calendar or setting the month to only show all-day events.

PostPosted: Thu Jul 29, 2010 8:56 am
by kaostika
Yeah, the month to month only shows 5 records per day. I am not sure why they use it since there are 20 records per day. I think i need to ween them off that view or find out what they are doing first

Oreste