VPN, PacketSize?!

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
fabilson
Posts: 3
Joined: Thu 30 Aug 2018 12:09

VPN, PacketSize?!

Post by fabilson » Thu 30 Aug 2018 12:20

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
Devart Team
Posts: 1137
Joined: Mon 06 Jul 2015 11:34

Re: VPN, PacketSize?!

Post by MaximG » Mon 03 Sep 2018 06:53

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
Posts: 3
Joined: Thu 30 Aug 2018 12:09

Re: VPN, PacketSize?!

Post by fabilson » Wed 05 Sep 2018 12:30

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
Devart Team
Posts: 1137
Joined: Mon 06 Jul 2015 11:34

Re: VPN, PacketSize?!

Post by MaximG » 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;

fabilson
Posts: 3
Joined: Thu 30 Aug 2018 12:09

Re: VPN, PacketSize?!

Post by fabilson » Tue 11 Sep 2018 11:25

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?

MaximG
Devart Team
Posts: 1137
Joined: Mon 06 Jul 2015 11:34

Re: VPN, PacketSize?!

Post by MaximG » Tue 11 Sep 2018 12:50

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

Post Reply