Update, for anyone interested. The root cause was NOT the firewall or JDBC inherently. The Ignition server is Windows 2019, and the root issue can be traced to the implementation of Nagle's Algorithm for TCP queuing. Adding 'tcp no delay=true' to the connection properties disables this and brought our query time down to the expected 2ms.
, Nagle's algorithm - Wikipedia
5 Likes