Data population in database?

• Megha Yadav

  SSCommitted

  Points: 1735

  More actions

  November 15, 2007 at 12:29 am

  #179342

  I have come across a scenario where in i am being passed in the data and i just need to insert it ....

  Even the GUID's (forming the FK's) are created and passed from a .NEt application and i just need to insert it into the database ....

  IS data creation at DB level a performace hit?

  Should data be created at DB Level ?

  Do provide me with yoru suggestions...

  Thanks

• Grant Fritchey

  SSC Guru

  Points: 399020

  More actions

  November 15, 2007 at 5:46 am

  #751459

  What do you mean by "data created at the database level"?

  Do you mean, is it more or less performant to create a GUID or some other type of primary key on the database as opposed to simply doing an insert? Well, yeah, there is a slight hit for that type of operation. Most applications will never see it because the vast majority of the cost is the actual i/o operation of writing the data on the disk.

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning