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(a)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-tp19739140p1983146…
Sent from the OpenSER Users Mailing List mailing list archive at
Nabble.com.