Inserts into table from .NET application

General
Fan

Inserts into table from .NET application

There is a .net application which is inserting data into a table in Teradata and it appears this is consuming more time than expected.  Are there any recommendations for how .net applications should perform insert statements to Teradata tables when needed?

In the logs, I see:

INSERT INTO account_tmp (ID, ACCOUNT_NBR) VALUES (?, ?);

INSERT INTO account_tmp (ID, ACCOUNT_NBR) VALUES (?, ?);INSERT INTO account_tmp (ID, ACCOUNT_NBR) VALUES (?, ?);

INSERT INTO account_tmp (ID, ACCOUNT_NBR) VALUES (?, ?);

 

Elapsed time is     0:00:00.090000 on average for each insert statement.  However, looking at the logs, there is a 1 second delay inbetween each insert statement.  The application is sending each insert statement immediately after the previous statement completes.  It can send 50+ statements each time this process executes.

1 REPLY
Teradata Employee

Re: Inserts into table from .NET application