Recent content by pat_laeda

Does DOA supports /*append*/ hint for insert data? I use TOracleQuery.ExecuteArray() for insert, but size of table segment still growing like /*append*/ hint doesn't use. --insert insert /*APPEND*/ into T1 (DATETIME_, p_01, s_01) values (:d, :p , :s) -- get size of segment select...

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...

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...