Devart Forums

Hello,

Delphi 10.3.3, UniDAC 8.1.2

One of our customers do use a VPN connection on port 3600 (not standard port) to connect to a MySQL server.
The issue is that some very light queries that returns only a row (no blobs) needs 5 seconds.
Using HeidiSQL with libmysql.dll trough same VPN is fast (milliseconds).
Without VPN (in local network) is also fast. VPN is used to connect from outside.
Using libmysql.dll is now deprecated and I don't know what to do.
I will try probably to see if I can see something with Wireshark.

What do you recommend?

It was an TUniQuery with UniDirectional = True.
Why only on VPN it was so slow I can't understand.
5 sec. vs. 80 msec. (in internet).
In some cases it was only a table with a few rows and query returned one row with a short string. On VPN with UniDirectional=True it was very slow.
I don't have more time now to investigate.

Unfortunately, we haven't been able to reproduce the issue.
Please create an example demonstrating the incorrect behavior and send it to us, along with test credentials for logging in to your server via VPN, through the contact form (https://devart.com/company/contactform.html). We'll try to investigate the issue to come up with a solution.