Fast import 10.000 rows

[crucifix]

Hi.

I'm doing optimization in our code. I tried different scenarios with different components.

I have big table (150 fields) with trigger, pk, indexes and constraints.

I recognized, that the fastes way to import large number of records is to use BULK INSERT.
I created two procedures on Oracle, one for parsing values one for BULK INSERT.

I tried with ADO connection (TADOStoredProc) and with ODAC connection (TOraStoredProc and TOraLoader (for ordinary insert) with LmDML - because of trigger).

Insert time ADO: 6:00.181 minutes / 10.000 rows
Insert time ODAC: 6 minutes / cca. 1.000 rows (10 times slower) // this result if for StoredProc, OraLoader was more slower

Is there any diffrent approach in ODAC to achieve better performance than ADO for current issue?

Thanks for help.

[AlexP]

Hello,

Please send a complete sample, reproducing the described problem, including the scripts for creating database objects to alexp*devart*com.