Calling Stored Proc Simultaneously to Update Different tables.

• teekay-101299

  Mr or Mrs. 500

  Points: 585

  More actions

  March 20, 2008 at 1:18 pm

  #180333

  I have a stored procedue(SP) that I am using to load data from an SSIS process.

  The SP is dynamic and runs every 30 seconds. Meaning, based on the parameters I pass it, the SP will determine which tables to updates. Tables contain Varchar(50), Money, Dates, Integers. The tables have about 80 columns each.

  Is there a loss in performance with this approach? Meaning using the same SP to update different tables? Or should I use a different SP for each update process for better performance?

  Teekay

• GSquared

  SSC Guru

  Points: 260824

  More actions

  March 20, 2008 at 1:20 pm

  #792212

  Separate ones will end up with better performance, usually. This is due to stored execution plans.

  - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
  Property of The Thread

  "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon