November 15, 2007 at 12:29 am
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
November 15, 2007 at 5:46 am
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply