locked
Create vs Update in Ms Crm by c# RRS feed

  • Question

  • Hello guys ,

    Database design :

    Main Entity : Customer
    Related Child Entity : Phonenumber

    Requirement :

    Old Phone no list : 11 , 22 , 33 , 44 
    New Phone no list : 55 , 66

    I want that these new Phonenumber should replace old ones.

    I have two options :

    Option 1 - Perform Bulk Delete on old phones
        Perform Bulk Insert for new phones

    Option 2- Find difference ( 4 old phones - 2 new phones ) =2
    Only Bulk Delete Two phones
    Perform bulk update on two phones

    That is , delete 11 , 22 and update 33 <- 55 , 44 <- 66 in Bulk

    Which one will be faster ?
    Delete operation is common in both cases 
    So I wanted to know whether update might be faster than create.

    I would appreciate any suggestions regarding this.

    Thanks ,
    Om
    Friday, August 8, 2014 3:07 PM