It looks like your connection is getting overwhelmed. Two things you can do:
-
Try to consolidate queries
-
Increase the Max Active property for the DB connection in Ignition Gateway Configuration. It is an advanced setting on the connection edit screen.
The second one will increase the number of active connections to the database at a time. This assumes your DB allows that number of connections. The default setting is 8 but you can increase it to 20 or so.