AnsweredAssumed Answered

Upload to container field on FMS13 is extremely slow

Question asked by alext on Feb 8, 2014
Latest reply on Feb 12, 2014 by philmodjunk

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.

Outcomes