Devart Forums

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.

Hello,

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