Hi,
=20
In my test case, i insert many (about 10'000) rows (row by row) into a
table:=20
=20
for (int il =3D 0; il < 10000; il++) {
myCommand->CommandText =3D String::Format("INSERT INTO =
punktetabelle(PTNR,
XP, YP, ZP) Values('{0}', '1.11', '2.22', '3.33')", il.ToString());
myCommand->ExecuteNonQuery();
}
=20
This is very slow (about 1 minute). When i do the same in a Stored =
Procedure
the speed is ok (about 1 second). Is this normal? I know that the .Net
Provider communicate always via TCP/IP.... do this 10000 =
insert-statement
produce so much overhead???
Is there a "quicker" way to insert many rows into a table via the .Net
Provider?
=20
thanks, thomas
=20
=20
|
