JSONFormatElements Performance

Lounge (Discussions)
42

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

Thanks @jwilling.

43

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.

1 Like
44

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

That's about the performance I would expect. :slight_smile: