Insert/Update Statements very Slow on AIX using ExecuteArray

Postby sebniepel » Thu 08 Jul 2010 17:02

Hello Stanislav,

We are very happy that 5.70.146 is finally out.

We tried to use DirectUtils.PacketSize = 32676 to manipulate the packetsize.

under mono we get the following:
Code: Select all
DEBUG - Devart.Data.Oracle.OracleException: Network error: 203
  at Devart.Data.Oracle.DirectUtils.a (Int32 A_0) [0x00000]


The magic size seems to be 4133. Below or equal is ok. above we can see the error.

We could not find any documentation for DirectUtils.PacketSize. Is this available?

We will try to cross check our solution with the demo solution you provided by exchanging the Devart assemblies.

Did we do anything wrong up to this point?

Kind Regards,
Sebastian
sebniepel
 
Posts: 9
Joined: Tue 08 Sep 2009 09:42

Postby StanislavK » Thu 08 Jul 2010 17:17

We've released dotConnect for Oracle 5.70.146 in which the DirectUtils class is implemented; it allows you to set the size of packets sent to the server (the PacketSize property). The new build can be downloaded from
http://www.devart.com/dotconnect/oracle/download.html
(the trial version) or from Registered Users' Area:
http://secure.devart.com/

For more information on improvements and fixes available in the 5.70.146 version, please refer to
http://www.devart.com/forums/viewtopic.php?t=18424
StanislavK
Devart Team
 
Posts: 1710
Joined: Thu 03 Dec 2009 10:48

Previous

Return to dotConnect for Oracle