Hi, I have a lot of events in the calendar and I'd like to speed up it. I don't need to see all the past events, but only the events of the previous week. I need prefilter events so: DateStart > Get (CurrentDate)-7.
I tried it following the instructions about filtering (creating a new filterglob_5 field, etc.) and it works quite good.
Is there another faster way to do this? Thanks
Damian

Hi Damian,

Thanks for your question. By its nature, the calendar already pre-filters events by date range, showing only those events that match the current view (e.g., day, week, month). So hard-coding a new pre-filter to exclude events that fall outside the viewable range wouldn't change anything because it's already happening.

To improve performance, you might consider filtering by some other attribute, such as 'status' or 'resource'.

Here are some articles that explain how to improve calendar performance:

Calendar Pro 12...
http://www.seedcode.com/pmwiki/pmwiki.p ... ar12.Speed
http://www.seedcode.com/pmwiki/pmwiki.p ... 12.Filters

Calendar Pro 11...
http://www.seedcode.com/pmwiki/pmwiki.p ... ndar.Speed
http://www.seedcode.com/pmwiki/pmwiki.p ... ar.Filters

Let me know if I can help any further.

Jeff

Thanks Jeff,
I'm using the calendar with many events and no need to show past events.
I got filter in this way:
I created a new field (SampleEvents) "view": Case (DateStart> CalendarInterface :: Today - 15, "Yes", "No"), and another field: filterglob_5 field (CalendarInterface).
I modified the script "Load settings on startup ..." adding some steps.

It works correctly.

But I don't know if this filtering speeds up the calendar: Is it worth filter events in this way?
Thanks,
Damian

Hi Damian,

Performance and draw speed are determined by the number of events appearing on-screen at any one time. Therefore, pre-filtering events more than 15 days old will have no visible or performance effect on the day and week views. It would, however, reduce the number of events that appear on the month view, if that's what you're going for. You could also reduce the number of on-screen events by filtering out "closed" or "pending" events, for example.

Let me know if there's anything else I can help with.

Jeff

Thanks, Jeff, if pre-filtering events will have no visible effects on the calendar speed, I prefer not to do that. Thanks for your help

Tell you what I do.. write a piece of Filemaker code to copy purge, even just delete old event files.. My application I have a portal to view the event file or files..Delete all/// even populate new records from my app.. by doing so, it auto increment its Id field anyways... then just refresh SC... see my 7 min demo adding/ RATHER linking its 1 event file/// Seedcodes really going to enhance my telephone answering service application and buz Thks SC

http://www.mastar.com/Presentations/OnCalCalendar/QuicOnCallCalendar/QuicOnCallCalendar.html

...or thinking about this... copy certain older records to a date coded event file. The what if, in the SC app, under Sources, its shows your event file.. like the Yoga example, show these datecode files... if you must just link it in.. I am going to try that one.. haven't gotten to Yoga yet.. even that much of this app but immediate integration cheers

What did he say?