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

toly hippo_big at hotmail.com
Mon Oct 6 05:20:34 CEST 2008


Hello Daniel,

I can answer about Sybase: update is delete/insert, and optimizer will do it
more effectively the executing 2 different transaction.

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
> 
> 

-- 
View this message in context: http://www.nabble.com/-offtopic--update-vs-delete-insert-tp19739140p19831461.html
Sent from the OpenSER Users Mailing List mailing list archive at Nabble.com.





More information about the Users mailing list