Good afternoon!

We use TUniConnection in our applications, using in most cases the PostgreSQL database.

We are experiencing problems related to slowness, especially when our customers use VPN for the connection.

We are currently using the parameters below:

TUniConnection.Options.LocalFailover := True;

TUniConnection.Options.SetFieldsReadOnly := False;

TUniConnection.Options.RequiredFields := False;

TUniConnection.CachedUpdates := True;

TUniConnection.LockMode := lmOptimistic;

TUniConnection.SpecificOptions.Values['PostgreSQL.SSLMode'] := 'smDisable';

TUniConnection.SpecificOptions.Values['PostgreSQL.ProtocolVersion'] := 'pv30';

TUniConnection.SpecificOptions.Values['PostgreSQL.UnknownAsString'] := 'True';

TUniConnection.SpecificOptions.Values['PostgreSQL.DeferredBlobRead'] := 'True';

TUniConnection.SpecificOptions.Values['PostgreSQL.ExtendedFieldsInfo'] := 'False';

  

We would like to know what are the best parameters to get the connection safely and as quickly as possible in case of high latency.

Thanks!