sql Insertion Speed

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

speedwave - 27 Jan 2006 04:17 GMT

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)

Reply to this Message

Immy - 27 Jan 2006 16:15 GMT

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

>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)

Reply to this Message