6 Replies Latest reply on Jan 28, 2012 1:54 PM by paulspafford

    Calendar over WAN

    paulspafford

      I have a client who I created a runtime for a few years ago. At the time I wasn't worried about network performance, since it was on a runtime, but now he's hired a virtual assistant and wants it networked.

       

      This calendar 6 records, and each has seven portals on it. So that's 42 portals based on a global field and some unstored calcs. Performance sucks. Whenever he switches dates, it takes anywhere from five to eight seconds to refresh.

       

      First thing I tried: I made each record related to just a week, with seven filtered portals for the days of the week. That's no faster.

       

      Then: I made a virtual list table with a script that grabs all the sessions in that date range and sets them into variables. Then it has 42 portals on a single record layout that are all based on a cartesian relationship, but are filtered to a different date in the range.

       

      That's no faster. The script is reasonably fast, but the screen redraw is still pretty slow.

       

      Any other ideas? Do I want to have a single record with 42 repeating repeating fields, maybe?

       

      Thanks,

      Paul

        • 1. Re: Calendar over WAN
          jormond

          I've seen some people use a repeating field just to display the calendar.  Imports with all the data pushed into a repeating field it much faster than importing all the fields in a single import.  You could import the records into a calendar display table. And just push updates/edits to the actual table and push an import into the display table.

           

          Then you only need to go to the record to make edits.

          • 2. Re: Calendar over WAN
            paulspafford

            Yep, that's what I'm trying right now. Early tests are proving it to be faster.

             

            Thanks,

            Paul

             

             

             

            --

            Paul Spafford

            FileMaker Database Superhero,

            Spafford Data Solutions

             

            Tel: 613 838 9956

            www.paulspafford.com

            www.ottawafilemakerdeveloper.com

            www.fmlayoutmode.com

            www.fmscripts.com

             

            FileMaker User Group in Ottawa:

            www.meetup.com/fudgeo

            • 3. Re: Calendar over WAN
              timwhisenant

              Paul,

               

              Is it the UI redraw that seems to slow it down or the data traffic. Doesn’t seem that a lot of data should travel in a calendar.

               

              What about separation? UI file local and Appointment data hosted.

               

              In my experience the heavy lifting of a calendar is usually UI.

               

               

               

              HTH

               

              Tim

               

               

               

              Timothy R Whisenant

               

              Plastic Fusion Fabricators, Inc.

              • 4. Re: Calendar over WAN
                JohnSindelar

                Hey Paul,

                 

                Check out our free calendar, it uses a virtual list and a single portal. Should give you some ideas, or you can paste it into your own file as a starting point.

                 

                HTH,

                 

                John

                • 5. Re: Calendar over WAN
                  paulspafford

                  I'll have a look, John -- thanks! I remember looking at this a few years ago and thinking it was the cleanest relationship graph I'd ever seen on a calendar, and that was before you started using the virtual list.

                   

                  Paul

                   

                   

                   

                  --

                  Paul Spafford

                  FileMaker Database Superhero,

                  Spafford Data Solutions

                   

                  Tel: 613 838 9956

                  www.paulspafford.com

                  www.ottawafilemakerdeveloper.com

                  www.fmlayoutmode.com

                  www.fmscripts.com

                   

                  FileMaker User Group in Ottawa:

                  www.meetup.com/fudgeo

                  • 6. Re: Calendar over WAN
                    paulspafford

                    Hey Tim,

                     

                    The repeating field method started out faster, but then I started adding all the extra bits in: Conditional formatting; holidays; sessions available per day; instructor for the session; more conditional formatting. It's starting to slow down again. So some of this disparate data, along with the UI are causing the problem. I'm not sure that a local UI file can save the day here.

                     

                    I'm going to have a look at SeedCode's free calendar and see if it can save the day.

                     

                    Thanks,

                    Paul

                     

                     

                    --

                    Paul Spafford

                    FileMaker Database Superhero,

                    Spafford Data Solutions

                     

                    Tel: 613 838 9956

                    www.paulspafford.com

                    www.ottawafilemakerdeveloper.com

                    www.fmlayoutmode.com

                    www.fmscripts.com

                     

                    FileMaker User Group in Ottawa:

                    www.meetup.com/fudgeo