SQL Table Insert rate?

Question

SQL Table Insert rate?

Virender Sihag

Say Hey Kid

Points: 688
More actions
July 1, 2010 at 7:12 am

#237169

This should be the easiest question for you all.
My question is:
how many records i can insert into a table per second?
Note:
I am not using select * into...
I dont want to use bulk insert.
There are no triggers, primary keys and indexes on the table
No other application is accessing this table.
All the columns this table are of type varchar(200)
Total Number of columns are 108.
Plz tell me if you need more information.
[font="Arial Narrow"]Failure is not the worst thing. The worst Thing is not to try[/font]

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004494 More actions · Answer 1

virender.singh (7/1/2010)
This should be the easiest question for you all.
My question is:
how many records i can insert into a table per second?

It depends.

Depends on hardware, size of table, indexes present, concurrent activity, probably several more things as well.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Eugene Elutin SSC Guru Points: 59322 More actions · Answer 2

You will find comparison table in this article:

http://msdn.microsoft.com/en-us/library/dd425070(SQL.100).aspx">

http://msdn.microsoft.com/en-us/library/dd425070(SQL.100).aspx

_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)

How to post your question to get the best and quick help[/url]

Paul White SSC Guru Points: 150457 More actions · Answer 3

Eugene, you included some tags in that link by mistake. This version works:

http://msdn.microsoft.com/en-us/library/dd425070(SQL.100).aspx

I'm not sure it will help virender too much, but it's all good useful information.

As far as the original question is concerned, it really does depend, but even with single-row INSERT statements, most servers should be able to do many thousands of rows per second. This is, of course, a daft way to do it.

Eugene's link shows better methods.

Paul

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

Eugene Elutin SSC Guru Points: 59322 More actions · Answer 4

Thank you Paul, I have no idea of how these rubbish tags end-up in the link I've posted. 😀

_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)

How to post your question to get the best and quick help[/url]

Virender Sihag Say Hey Kid Points: 688 More actions · Answer 5

Thank you GilaMonster, Eugene and Paul for your valuable inputs

@paul-2 : I will cheer for newzeland during next india-newzeland battle;-)

[font="Arial Narrow"]Failure is not the worst thing. The worst Thing is not to try[/font]

Gail Shaw SSC Guru Points: 1004494 More actions · Answer 6

virender.singh (7/2/2010)
@Paul : I will cheer for newzeland during next india-newzeland battle;-)

Cheer for South Africa next time we play India! We're more likely to win. 😉 :hehe:

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

ColdCoffee SSC-Dedicated Points: 39971 More actions · Answer 7

GilaMonster (7/2/2010)
virender.singh (7/2/2010)
@Paul : I will cheer for newzeland during next india-newzeland battle;-)
Cheer for South Africa next time we play India! We're more likely to win. 😉 :hehe:

I will be cheering for my India...20-20, we suck, but ODI and Test, india are teh team to beat! Beating them isnt as easy for Smith's gang as SQL server is easy for you, Gail! :w00t: 😛

Eugene Elutin SSC Guru Points: 59322 More actions · Answer 8

ColdCoffee (7/2/2010)
...
I will be cheering for my India...20-20, we suck, but ODI and Test, india are teh team to beat! Beating them isnt as easy for Smith's gang as SQL server is easy for you, Gail! :w00t: 😛
...

After one of my Indian friends explained me the cricket rules (which I've failed to understand during the 10 years life in AUS), I can also support some team.

The best cricket game I ever seen wasn't too long ago (last world champ or cap in SA?). It was a very special game, as all Indians on our floor were supporting team from...

PAKISTAN!!! :w00t: 😀 :w00t:

Eeeee, it was between Pakistan and Australia, and if Pakistan would win, India team whould be playing in final. It didn't happen so :ermm:

Actually, should be the SPORT forum group be added as a one with dedicated forums for the different SPORTS 😀

I'm not sure if Editor will like this idea :w00t:

_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)

How to post your question to get the best and quick help[/url]

Paul White SSC Guru Points: 150457 More actions · Answer 9

GilaMonster (7/2/2010)
virender.singh (7/2/2010)
@Paul : I will cheer for newzeland during next india-newzeland battle;-)
Cheer for South Africa next time we play India! We're more likely to win. 😉 :hehe:

Humph! 😎

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi