Insert/Update Statements very Slow on AIX using ExecuteArray

sebniepel · Post by **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

StanislavK · Post by **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