Jump to content

Initial Sync- Write Speed slows down during Sync


This topic is 1900 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I am having an issue where one of the tables I am syncing goes from 70 writes per sec to 5 writes per second. This write speed decreases incrementally through out the initial sync for the specific table. All other tables I am syncing hover around 70 writes per second. It is taking the iOS devices to write 7500 total records in 15 minutes. The problem table has 3100 of those records. This table takes 13 of the 15 minutes. 

Details of my solution:

  • iOS Client to MirrorSync 5 Server sync.
  • Mobile file is a separate trimmed down version of the hosted file.
  • All fields on sync layouts are text or number
  • Primary key in the table is a UUID
  • The sync is setup to not merge records
  • JSON is stored in one of the fields

In the past the initial sync would take around 7 minutes to complete. Somehow it has doubled. Any help would be appreciated!

Edited by tkakavros
Link to comment
Share on other sites

Usually, slow write speeds are caused by:

large amounts of text in a single field, such as an audit log field or base64 encoded text (you should never try to sync container data by base64 encoding it, you should let MirrorSync deal directly with the container field). It sounds like the field with JSON data might be an issue, if it’s large. 

Stored calculation fields in the slow table, even if they are not on the sync layout: FileMaker must calculate all stored calcs when writing a record. If there are too many calcs, or if some of them are very complex (e.g. recursive custom function), this can significantly slow things down. 

Container fields: as mentioned above, it’s better to sync a container field than to convert it to base64 text, but container data still takes significantly longer to sync. 

I would recommend creating a temporary copy of your solution that you can use to experiment with. Try removing the json field and see if that helps. If it doesn’t, try removing stored calcs and see if that helps. Then try removing container fields. Then try removing any text fields that contain more than a few kilobytes of text. If you’ve removed all of those things and it’s still slow, contact us about reviewing your sync logs. 

Link to comment
Share on other sites

This topic is 1900 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.