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@lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users