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(a)lists.kamailio.org
http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
--
Daniel-Constantin Mierla
http://www.asipto.com