|
Home > Archive > MS SQL Data Warehousing > January 2006 > sql Insertion Speed
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
sql Insertion Speed
|
|
| speedwave 2006-01-27, 3:23 am |
| 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
"speedwave" <suzuki@yahoo.com> wrote in message
news:e$v3NkvIGHA.1728@TK2MSFTNGP09.phx.gbl...
>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)
>
>
|
|
|
|
|