Page 1 of 1

VPN, PacketSize?!

Posted: Thu 30 Aug 2018 12:20
by 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.

Re: VPN, PacketSize?!

Posted: Mon 03 Sep 2018 06:53
by 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

Re: VPN, PacketSize?!

Posted: Wed 05 Sep 2018 12:30
by 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?

Re: VPN, PacketSize?!

Posted: Mon 10 Sep 2018 14:15
by MaximG
You can set the PacketSize variable value as follows :

Code: Select all

uses
... OraNet;

begin
OraNet.PacketSize := 4096;
end;

Re: VPN, PacketSize?!

Posted: Tue 11 Sep 2018 11:25
by fabilson
MaximG wrote:
Mon 10 Sep 2018 14:15
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?

Re: VPN, PacketSize?!

Posted: Tue 11 Sep 2018 12:50
by MaximG
The global variable PacketSize value will be used by all sessions used in you project