Why OraLoader loads data сonsiderably slower then sqlldr.exe ?
I'm using OnPutData method
Code: Select all
{
OraLoader1->Load();
}
void __fastcall TForm1::OraLoader1PutData(TOraLoader *Sender)
{
while (--data--)
{
OraLoader1->PutColumnData(0, Row, --data[0]--);
OraLoader1->PutColumnData(1, Row, --data[1]--);
OraLoader1->PutColumnData(2, Row, --data[2]--);
OraLoader1->PutColumnData(3, Row, --data[3]--);
OraLoader1->PutColumnData(4, Row, --data[4]--);
OraLoader1->PutColumnData(5, Row, --data[5]--);
....
OraLoader1->PutColumnData(19, Row, --data[19]--);
OraLoader1->PutColumnData(20, Row, --data[20]--);
Row++;
}
}
But if I user sqlldr.exe - I have 11000 str/sec
LoadMode = ImDML - because I have primary index in table
Is it possible to speed up process ?
Thank you,
TeleMax