2 Replies Latest reply on Dec 1, 2011 1:37 PM by TSGal

    Go Database Running Slow

    RachaelSmith

      Title

      Go Database Running Slow

      Post

      We have FM Go on an iPad2. We'll have 5 separate databases on the iPad- three are 700 kb, 2 are 1 mg. Only one will be open at a time. The one db thats open is running extremely slow! They're all script heavy with lots of conditional formatting.

       

      Any suggestions about why the open db is running so slow- obviously we suspect it's due to the app holding 5 pretty large databases?

      Any suggestions about how to reduce lag time?

       

       

        • 1. Re: Go Database Running Slow
          TSGal

          Rachael Smith:

          Thank you for your post.

          Without seeing your database file, it is difficult to determine what is causing the slow performance.

          Generally, the size of the database file does not impede performance.  Some things that do affect performance include background images, multiple Container fields, Web Viewer, as well as script triggers and conditional formatting.  If you have any background images on the Layout, return to FileMaker Pro, duplicate the layout, and remove all background images.  Then, select this new layout in FileMaker Go.  Does this help?

          Any other information you can provide about the layout may be helpful.  If you want, send in a copy (or clone) of your file, and I'll look at it and determine what can be done to help speed it up.  Check your Inbox at the top of this page for instructions where to send the file.

          TSGal
          FileMaker, Inc.

          • 2. Re: Go Database Running Slow
            TSGal

            Rachael Smith:

            I received your file and directions.

            Yes, the reason for the slow performance is caused by the radio buttons.  All fields with a value list takes a little longer to respond than other fields.  Our Development and Testing departments are aware of this issue.

            One user has worked around this problem by making each of the value list items a button, that when tapped, executes a script to set the field to that value and displays a graphic next to the entry (in his case, a checkmark; in your case, a radio button).  I realize this is not an ideal solution, but it will help with faster data entry.

            TSGal
            FileMaker, Inc.