VPN, PacketSize?!

[fabilson]

Hello!

I´m using the ODAC component (TOraSession) over a VPN and would like to know how can I increase performance on connection.

I read about "PacketSize Variable" on Oranet, but I don´t know hou to implement it on my code.
If that is the answer for a better performance, could you send-me some piece of code using it.

My current version o f ODAC is 10.0.2
I use "Direct" mode

Thanks.

[MaximG]

The description of the PacketSize variable is provided in our documentation:
https://www.devart.com/odac/docs/devart ... etsize.htm
By default, the value of this variable equals 8192, which is the optimal parameter when using Windows family OS. You can select the required value of the PacketSize variable by checking each of them using performance tests in your test environment

[fabilson]

Thank you.

The description of it in documentation id helpfull, but I couldn´t find how to implement it.

Could you please, send me a piece of code explaining how can I change this parameter?

[MaximG]

You can set the PacketSize variable value as follows :

Code: Select all

uses
... OraNet;

begin
OraNet.PacketSize := 4096;
end;

[fabilson]

You can set the PacketSize variable value as follows :

Code: Select all

uses
... OraNet;

begin
OraNet.PacketSize := 4096;
end;

Thanks!

But I still have a question...
Do I have to put this piece of code for every OraSession that I have in my project or just one in the dpr project i enough?

[MaximG]

The global variable PacketSize value will be used by all sessions used in you project