I have tens of thosands of records needed to be insert to SQLserver on each
query.
My experience is that each 10 thansands records needs 7 sec.
Is there any method to increase the speed?
(I am writing ASP.NET + SQLserver application)

Hi,

You may get a better response if you posted this into the Programming
newsgroup, but here are my comments on your question.

1. Having an index on your table will slow down the insert. Therefore, you
could look at dropping the index, inserting the data and then re-add the
index. You would need to test if the time it takes to re-add the index
actually saves time for the complete process.

2. You can try to use BULK INSERT/COPY. Look up the syntax and advantages
(and dis-advantages) of using this method.

Immy

[quoted text, click to view]