2 Replies Latest reply on Sep 11, 2013 7:58 AM by DEC

    Filemaker Takes longer to construct reports over Server...


      Hi There!


      I've had my team sharing a Filemaker database over an internal network without Filemaker Server (ugh). I'm now testing the same database on a remote server. The bandwidth on both sides of this equation is outstanding (hundred plus MBPS), but the main report generated by the database takes seconds to compile on the local copy versus 30 seconds on the remote copy.


      There are summary fields on this report, and the database includes tens of thousands of records, but in any case the local copy has it up and ready to print in one second flat.


      Otherwise, I'm seeing zero latency issues whatsoever; in fact, the remote copy does everything else way faster, especially running the opening script.


      Any thoughts would be appreciated; thanks!



        • 1. Re: Filemaker Takes longer to construct reports over Server...

          That is sorta to be expected.  If you have a local copy then you already have ALL the data.  If the file is hosted on FMS, you have only the data that you need.  When you run a big report FMS has to ship you the data to be cached locally.


          If the data is mostly static you could "pre-aggreage" it on a schedule so that you don't have to keep summarizing the same data (for instance last year's sales by month -> not going to change anymore)


          There may also be other ways to run your report that do not involve summaries but for that we'd have to see the script and understand the data architecture.

          1 of 1 people found this helpful
          • 2. Re: Filemaker Takes longer to construct reports over Server...

            Thanks so much, my friend, and your advisement makes perfect sense.  The report in question, after all, is probably around 250-300 pages long; it's by a long shot the longest report I've seen generated out of any Filemaker solution I ever devised. In that regard, 30 seconds to compile doesn't slight Filemaker in the least; I've seen SAP solutions take minutes to compile far smaller reports : )


            I'll keep this notion in mind when devising solutions with potentially lengthy reports (especially those with summaries).  Thank you!