Support for our Calendar template, Time Tracking, Hierarchy and anything else you may be doing with FileMaker®. Welcome!
Subscribe via RSS

Back to seedcode.com
  

Log in Register Search SeedCode Support Forum Forum Index

Speed up month to month

 
Post new topic   Reply to topic    SeedCode Support Forum Forum Index -> SeedCode Calendar
View previous topic :: View next topic  
Author Message
kaostika



Joined: 16 Dec 2009
Posts: 52

PostPosted: Wed Jul 28, 2010 10:00 am    Post subject: Speed up month to month Reply with quote

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


Back to top
View user's profile Send private message
John Sindelar
SeedCode Staff
SeedCode Staff


Joined: 20 Nov 2003
Posts: 1988

PostPosted: Thu Jul 29, 2010 6:45 am    Post subject: Reply with quote

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.php?n=SeedCodeCalendar.Speed



_________________
John Sindelar
SeedCode LLC
Back to top
View user's profile Send private message Send e-mail Visit poster's website
kaostika



Joined: 16 Dec 2009
Posts: 52

PostPosted: Thu Jul 29, 2010 7:16 am    Post subject: Reply with quote

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


Back to top
View user's profile Send private message
kaostika



Joined: 16 Dec 2009
Posts: 52

PostPosted: Thu Jul 29, 2010 7:35 am    Post subject: Reply with quote

I only have one source.


Back to top
View user's profile Send private message
John Sindelar
SeedCode Staff
SeedCode Staff


Joined: 20 Nov 2003
Posts: 1988

PostPosted: Thu Jul 29, 2010 7:39 am    Post subject: Reply with quote

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.



_________________
John Sindelar
SeedCode LLC
Back to top
View user's profile Send private message Send e-mail Visit poster's website
kaostika



Joined: 16 Dec 2009
Posts: 52

PostPosted: Thu Jul 29, 2010 7:56 am    Post subject: Reply with quote

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


Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    SeedCode Support Forum Forum Index -> SeedCode Calendar All times are GMT - 9 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Home | Products | Contact Us

Powered by phpBB © 2001, 2005 phpBB Group
Theme created by Vjacheslav Trushkin

Telephone: (206) 715-2126