Hi,
this very much depends on the type of activity (the amount of queries and the data volume going back and forth)
and the bandwidth of the connection.
E.g. when you have a fast (1GBit, 10Gbit ....) Link between the machines, the response times should be comparable as in the local network,
which should have a similiar speed (or above, when in a high-speed data centre environment).
Fastest would be on the localhost, obviously.
A slower line (10mBit, 100mBit) will slow down the response times significantly, especially when a large number of queries
is prepared and executed.
When using a VPN link, you should check the resulting bandwidth, which has nothing to do with the physical bandwidth available,
but highly depends on the settings of your VPN connection.
Also, the MTU can be important, because packets get broken up into smaller chunks when running through VPN tunnels.
If the server reacts fast enough locally, then you should search for reasons in the connection, not the server itself.
If you cannot get around this slow connection and you want to speed up things, check how you application is working.
Depending on the implementation language, there might be some options to make the queries react faster.
First, only select data which you need (no "select * from ", if only a small number of fields are needed).
Reuse queries, (e.g. PreparedStatements in Java).
For large amounts of insert/update/delete operations, use bulk operations, these are faster than single operations
for massive data.
Best,
Original Message:
Sent: 2/19/2025 5:16:00 PM
From: eduardo rodriguez
Subject: Slow operations from a remote network
I have an application that when running on the same network as my instance takes an average of 5 minutes to perform operations, however from an external network it is impossible to generate. I have waited up to 1 hour. Is this due to Informix configuration or a connectivity issue?
------------------------------
eduardo rodriguez
------------------------------