JDBC Driver JTOpen increased performance

[Former Member]

Hi,

we use as JDBC drivers "JTOpen".

In our Szenario we have to insert in Datebase ca. 150.000

Idocs ( ARTMAS05). We use for this the Report "RSEOUT00"

with Packagesize 500.

Per Message the Adapter Engine needs ca. 6 minutes.

We belive that the batch mode in Channel will not be used.

Our XML Document show like this:

<StatementName2>

<dbTableName action=”INSERT”>

<table>realDbTableName</table>

<access>

<col1>val1</col1>

<col2>val2</col2>

</access>

<access>

<col1>val11</col1>

</access>

</dbTableName>

</StatementName2>

Know anybody a trick for increased performance ?

[Former Member]

Hi,

the time is per message, in one message are 500 Records.

best regards

Michael

[Former Member]

Hi,

It spends 6 minutes for each record, or for all 150.000 records?

regards.

roberti