if i fire simultanious 14 insert query per second,can it degrade the performance of SQL server 2005 with .net 2005 ?

• rajjs123

  Valued Member

  Points: 55

  More actions

  March 14, 2008 at 3:55 am

  #184142

  in my project, per second, i fire 14 insert query which insert two fields (1)time(varchar(11)) and (2)temparature(numeric(5,3) in 14 different tables.

  Whether these simultaneous operation affect(degrade) performance of my system or not?

  if yes, then how can i improve performance ?

  how can i solve this problem?

  is there any bulk insertion operation in sql which automatically perform batch insertion operation?

  pls, reply me. Quick

• SQL ORACLE

  One Orange Chip

  Points: 27807

  More actions

  March 14, 2008 at 9:33 am

  #789715

  Normally, not unless you insert "Jumbo" data and your tables have many some weird indexes.

  Your inserts are for different tables. You will only have table locks if there is no connections to other tables in your WHERE/JOIN clauses.

  Make a long story short. If your insert is "tiny", if your inserts do not have relations among tables, you do not need to worry about it.