I have a script that runs fine in the script console but adding it as a gateway (tag change) script the result is different.
I think this is due to the script console using a single thread whereas the gateway uses multithreading.
I tried using invokeAsync in the gateway but even though I’m using S+F it drops results, log shows “java.lang.Exception: Unable to add data to memory buffer, buffer full.”
My script is split into two parts, first I open a log file looping through 5 machines over LAN, split the CSV and insert into SQL (S+F).
The next part is to compare the timestamps of each record in the files and calculate the delta. Before using Invoke, I think the two for loops were running at the same time in a separate thread.
Each file has around 15K lines per day (I plan to run this script once at 00:30:00 to check yesterday’s data) and currently I’m looking at 5 machines but that will likely increase.
What’s the best way to move forward?