ExecuteArray and TimeStamp

[pat_laeda]

Does DOA support fast insert array of Timestamp?
I'm using oracle 10g and need to insert over 10 000 records per second into table

DATA (DATETIME_ TIMESTAMP(6),
P_01 NUMBER,
S_01 NUMBER)

Field DATETIME_ must include a milleseconds.
In demo application "DirectPath" showed how to insert array fast, but array consist of simple variables.

How can i make fast insert for TOracleTimestamp object?

 

[pat_laeda]

I can get OracleString from TOracleTimeStamp and insert it into my table as string.

Problem solved, but insert speed change from 100 000 to 30 000 rec/sec

How can we make speed more fast and keep using timestamp type?

We do not have a right to change type of field datetime_ from timestamp(6) to another type.

 

[Marco Kalter]

You cannot perform array inserts with object types like TOracleTimeStamp. You will have to use a string representation. Performance will be optimal, but it's some more work to convert.