Jump to content
Ocean West

JSON Array payloads for faster syncing

Recommended Posts

Ocean West    106

In an offline file a traditional sync would mirror all the data from the host to the files however in some work flows that could take longer for the initial sync especially for a lot of resource tables needed just for navigation or system logic.

now that we have native JSON parsing in FM16 would it be faster to sync a single table with arrays of information and then logic on the remote device to explode out to interface tables or virtual lists table based on the array over mirroring multiple tables and records.

Especially if the sync is only a one way push out to the remote and business logic doesn't require these tables to be modified or sync back to the host. 

 

Share this post


Link to post
Share on other sites
Jesse Barnum    51

We're already pretty much doing what you're talking about, but instead of JSON we do a return-separated list of Let($field1=value1; $field2=value2; etc...).

Share this post


Link to post
Share on other sites
jbante    141

The new JSON functions have many admirable advantages for performing certain operations. Speed is not one of them. (Unless the serialized data format is JSON, there's nothing you can do to change that, and the only alternative parsing method is other built-in FileMaker functions.)

Share this post


Link to post
Share on other sites

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


×

Important Information

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