Post reply

Data population in database?

  • 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

  • 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 RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software

Viewing 2 posts - 1 through 1 (of 1 total)

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