Jump to content
crayfish

JSON parsing performance comparison

Recommended Posts

I've been using Daniel Smith's JSON scripts from (http://www.modularfilemaker.org/module/json/) to parse JSON.

It's worked quite reliably (thanks Daniel!), but I'm wondering if anyone has compared its parsing speed to MBS's JSON plugin or the new native Filemaker 16 JSON functions? I'm still on 15. I'm working with some larger JSON files that are taking a long time to parse and hoping for a faster solution.

Any data on which option parses JSON fastest? Any disadvantages/advantages to each option?

Thanks!

Share this post


Link to post
Share on other sites

Haven't compared it to MBS parsing but I was using both the modularFileMaker ones and the BaseElements one.

The CF and scripted version on ModularFileMaker I abandoned for speed reasons.  The BE plugin was just faster.  The FM16 ones seemed to me to be on par.

Share this post


Link to post
Share on other sites
Posted (edited)

What is the time spent on parsing intervals of 10 000, 100 000, 1 000 000 records 10 fields, datatypes mixed( timestamp, text[5-255], number )?

Did you make a benchmark between FM and MBS's methods?

Edited by ggt667

Share this post


Link to post
Share on other sites

Yes. FileMaker parses the JSON for every single query.

The MBS Plugin can parse once and than reuse the same structures in memory to query. So the plugin will always be magnitudes faster.

  • Like 1

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.