# JSONFormatElements Performance

**URL:** <https://the.fmsoup.org/t/jsonformatelements-performance/1337>\
**Category:** Lounge (Discussions)\
**Tags:** scripting\
**Created:** [September 24, 2020, 2:37pm UTC](https://the.fmsoup.org/t/jsonformatelements-performance/1337 "2020-09-24T14:37:57Z")\
**Posts on this page:** 3\
**Page:** 3

<div class="post-metadata">

**Author:** ![anon45965781](https://avatars.discourse-cdn.com/v4/letter/a/13edae/32.png) [@anon45965781](https://the.fmsoup.org/u/anon45965781)\
**Post date:** [September 26, 2020, 5:52pm UTC](https://the.fmsoup.org/t/jsonformatelements-performance/1337/42 "2020-09-26T17:52:06Z")

</div>

Gotcha. Well, in any case, the performance of that approach looks to be really good.

Thanks @jwilling.

---

<div class="post-metadata">

**Author:** ![apjcs](https://yyz2.discourse-cdn.com/flex030/user_avatar/the.fmsoup.org/apjcs/32/2502_2.png) [@apjcs](https://the.fmsoup.org/u/apjcs)\
**Post date:** [September 29, 2020, 3:34pm UTC](https://the.fmsoup.org/t/jsonformatelements-performance/1337/43 "2020-09-29T15:34:05Z")

</div>

The custom function I use validates daily.json in between 0.5 and 0.9 seconds. JSON in a text field of remote hosted DB. FileMaker Server/Pro 19

```
Let(
[
~isArray = Left( text ; 1 ) ="[" ;
~test = If( 
	~isArray ; Left( JSONGetElement ( text ; 0 ) ; 1 ) ; 
			Left( JSONGetElement ( text ; "xxxxxxxx" ) ; 1 )
		)
];

~test ≠ "?"

)

```

Interestingly, JSONFormatElements() also takes less than a second.

---

<div class="post-metadata">

**Author:** ![anon45965781](https://avatars.discourse-cdn.com/v4/letter/a/13edae/32.png) [@anon45965781](https://the.fmsoup.org/u/anon45965781)\
**Post date:** [September 29, 2020, 5:22pm UTC](https://the.fmsoup.org/t/jsonformatelements-performance/1337/44 "2020-09-29T17:22:07Z")

</div>

Benchmarks! Looks good. I found similar performance using these functions.

That's about the performance I would expect. 🙂

[Previous page](https://the.fmsoup.org/t/jsonformatelements-performance/1337.md?page=2)