[Kamailio-Users] [offtopic] update vs delete/insert

Daniel-Constantin Mierla miconda at gmail.com
Mon Oct 6 16:59:06 CEST 2008


Hello,

On 10/06/08 06:20, toly wrote:
> Hello Daniel,
>
> I can answer about Sybase: update is delete/insert, and optimizer will do it
> more effectively the executing 2 different transaction.
>   
good to know that some db systems are doing this way. Thanks!

Daniel
> Toly 
>
>
>
> miconda wrote:
>   
>> Hello,
>>
>> I am trying to get out you knowledge as DBA ... in some discussions in 
>> the past was brought out that in some cases doing a delete on primary 
>> key followed by a pure insert might be faster than one update. It might 
>> be dependent of DB server type and perhaps the question would have 
>> better answer in appropriate db-specific mailing lists, but I want to 
>> see if some of you has more experience/insights about this and is 
>> willing to share or got into same dilemma.
>>
>> Thanks,
>> Daniel
>>
>> -- 
>> Daniel-Constantin Mierla
>> http://www.asipto.com
>>
>>
>> _______________________________________________
>> Users mailing list
>> Users at lists.kamailio.org
>> http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
>>
>>
>>     
>
>   

-- 
Daniel-Constantin Mierla
http://www.asipto.com





More information about the Users mailing list