3 Replies Latest reply on Feb 12, 2014 12:13 PM by philmodjunk

    Upload to container field on FMS13 is extremely slow

    alext

      Summary

      Upload to container field on FMS13 is extremely slow

      Product

      FileMaker Server

      Version

      FileMaker Pro Server 13 (server), FileMaker Pro 13 & FileMakerPro Advanced 13

      Operating system version

      Mountain Lion and Mavericks

      Description of the issue

      I have a huge problem uploading pdf documents from FMP13 client into a container field on FMP13 server.

      I manage a fairly elaborate FMP database for my company which uses at least 5 separate databases all tied together including Contacts, Documents, Prefs, Invoices, etc running on a server.  I'm having a problem with Documents, specifically the container field within it.  Contacts & Documents are both stand alone databases tied setup as a one to many relationship.  Documents database houses the container field obviously, where the actual document is embedded.  This was so contacts database would not slow as document counts grew.

      When we updated the server (FMS) and the clients (FMP regular & Advvanced) to v13, some of the clients were experiencing what appeared to be a slow upload (over a minute to insert a 150KB pdf file).  I decided to use 13's feature to store the container data externally to a secure folder to see if that would help.  When I did that everyone experienced the "slow upload" issue.  When I tried the same procedure with FMP12 advanced, the upload is almost instantaneous, tried again with my FMP 13 advanced and it took me 1m22sec to upload the same file.

      The "slow upload" appears on my mac (2.7GHz, i7, 16 gig RAM, OSX10.8.5, 50+Mbps i'net) as a spinning rainbow wheel.

      I've searched the forums & online and can't find anything about this.

      Steps to reproduce the problem

      Upload a pdf around 500KB from FMP13 client to FMS13 into a container field (if container stores externally AND "secure", then upload time takes even longer than when embedded).

      Use FMP12 client to upload the same file to the FMS13 field as before and you'll find upload time is very fast in comparison.

      Expected result

      Upload should time should be the same using FMP13 and FMP12,

      Actual result

      FMP13 takes approximately 160x longer (80+ seconds vs less than 1 second).

      Workaround

      Use FMP12 instead of FMP13.

        • 1. Re: Upload to container field on FMS13 is extremely slow
          TSGal

               Alex Theoret:

               Thank you for your post.

               I am unable to replicate the issue.  Here are the steps I took:

               1. In FileMaker Pro 13.0v1, I created a table with two Container fields: "Container" and "Interactive Container".  I set both fields to Store container data externally and Secure storage.

               2. In Layout Mode, I set "Interactive Container" for Interactive content.

               3. I set the file for Network Sharing.

               4. I uploaded the file to FileMaker Server 13 on a Mac OS X 10.9.1 machine.

               5. Using FileMaker Pro 13.0v1, I accessed the hosted file, went into Manage Database to verify the Container fields were still set for Remote and Secure storage.

               6. In "Container", I selected Insert Picture, and inserted the FileMaker 13 WebDirect Guide PDF file (633 KB), and the insertion was immediate.

               7. In "Interactive Container", I selected Insert PDF using the same WebDirect Guide PDF, and it took less than two seconds.

               Let me know what I'm doing differently than you.

               Make sure ports 80 and 443 are open (especially the latter for secure storage).

               TSGal
               FileMaker, Inc.

          • 2. Re: Upload to container field on FMS13 is extremely slow
            alext

                 Wow, I didn't even think to check the ports.  Port 443 is not required prior to FMP13, when I opened this port on the server the issue was resolved, thanks so much! 

                 A side note for anyone else that's had complications after changing container field storage to secure external folder- our system sends email with some of these [now secure] documents as attachments.  Attachments used to work by pointing to the file path, however this doesn't seem to be possible with secure documents so I had to "export" the container contents to the client temp folder before attaching to the email client.

            • 3. Re: Upload to container field on FMS13 is extremely slow
              philmodjunk

                   Well that's pretty much a key "feature" of "secure" storage--the file paths to the individual files are deliberately hidden in order to better protect them.