====== JSON Data Benchmark Testing ======


===== PHP Stopwatch =====
[[https://www.dokuwiki.org/plugin:stopwatch|Stopwatch plugin]] measures execution time of PHP code:
  * ''%%<stopwatch reset>%%'' - Resets stopwatch to zero.
  * ''%%<stopwatch show>%%'' - Show elapsed time in seconds since last reset.


===== Recursive JSON load =====
Here is JSON data with src attribute, which links to itself. So it is recursively loaded 30 times.
<code>
<stopwatch reset>
<json id=cookie path=cookie src=benchmark#cookie display=combined,log*>
{
  "name": "Butter cookie",
  "type": "cookie",
  "Ingredients": {
    "eggs": "3",
    "flour": "500 g",
    "sugar": "300 g",
    "butter": "250 g"
  }
}
</json>
Time elapsed: <stopwatch show>
</code>
<stopwatch reset>
<json id=cookie path=cookie src=benchmark#cookie display=combined,log*>
{
  "name": "Butter cookie",
  "type": "cookie",
  "Ingredients": {
    "eggs": "3",
    "flour": "500 g",
    "sugar": "300 g",
    "butter": "250 g"
  }
}
</json>
Time elapsed: <stopwatch show>


===== Load multiple files into JSON array =====
Here is one long JSON file with random data: [[.1000files:file1]]. For testing purposes it should be copied to different filenames 1000 times. Here is bash command for this:
<code bash>for i in {2..1000}; do cp file1.txt "file$i.txt"; done</code>

==== Load one file ====
<stopwatch reset>
<json path=stack1[] src=.1000files:file1 display=combined,log*></json>
''%%<json path=stack1[] src=.1000files:file1 display=combined,log*></json>%%''\\
Time elapsed: <stopwatch show>

==== Load 112 files ====
<stopwatch reset>
<json path=stack2[] src=.1000files:file1* display=combined,log*></json>
''%%<json path=stack2[] src=.1000files:file1* display=combined,log*></json>%%''\\
Time elapsed: <stopwatch show>

==== Load 1000 files ====
<stopwatch reset>
<json path=stack3[] src=.1000files:file*></json>
''%%<json path=stack3[] src=.1000files:file*></json>%%''\\
Time elapsed: <stopwatch show>

==== Single item ====
<stopwatch reset>
''%%%$stack2.55.0.friends.0.name%%%''\\
%$stack2.55.0.friends.0.name%\\
Time elapsed: <stopwatch show>

==== Table of 112 files ====
<code>
%$stack2[]{"Name0":0.friends.0.name, "Name1":1.friends.0.name, "Name2":2.friends.0.name, "Name3":3.friends.0.name, "Name4":4.friends.0.name, "Name5":5.friends.0.name, "Name6":6.friends.0.name, "Name7":7.friends.0.name, "Name8":8.friends.0.name}%
</code>
<stopwatch reset>
%$stack2[]{"Name0":0.friends.0.name, "Name1":1.friends.0.name, "Name2":2.friends.0.name, "Name3":3.friends.0.name, "Name4":4.friends.0.name, "Name5":5.friends.0.name, "Name6":6.friends.0.name, "Name7":7.friends.0.name, "Name8":8.friends.0.name}%\\
Time elapsed: <stopwatch show>

==== Table of 1000 files ====
<code>
%$stack3[]{ ... }%
</code>
<stopwatch reset>
%$stack3[]{"Name0":0.friends.0.name, "Name1":1.friends.0.name, "Name2":2.friends.0.name, "Name3":3.friends.0.name, "Name4":4.friends.0.name, "Name5":5.friends.0.name, "Name6":6.friends.0.name, "Name7":7.friends.0.name, "Name8":8.friends.0.name}%\\
Time elapsed: <stopwatch show>

==== Show JSON data of 112 files ====
This is most time consuming:
<code>
%$stack2 #code#%
</code>
<stopwatch reset>
%$stack2 #code#%
Time elapsed: <stopwatch show>