For reference purposes, I was able to compare performance the same webdev script in both v7.9.9 (b2018081621) vs 7.8.4 (b2016082217) using the HSQL hack.
I take speed measurement using Chrome Dev tools calling the webdev module to get the json with 793 tags of data with the following format, bot Ignitions reading from the same source, only one instance enabled at the same time *(for those tags).
timestamp: "2018/10/26 16:06:42"
7.8.4 (b2016082217) using the HSQL hack.
- 4.7 seconds
- 4.47 seconds
- 4.11 seconds
- 3.98 seconds
- 8.44 seconds
- 7.55 seconds
- 10.52 seconds
- 7.96 seconds
As a point of note, the v7.9.9 IGN instance is only running this set of tags for a single line (pretty light workload), while the v7.8.4 is running about 16 lines and has multiple processes pulling data at the same time, therefore it currently has considerably workload (we have about 50k tags in this instance).
The performance is considerably different, I will be opening a ticket with IA support, but wanted to share this.