Re: Performance Question

In article <200606141557.37321.terry@esc1.com>,
Terry Lee Tucker <terry@esc1.com> wrote:

% elements of 50 thousand records on 8 structurally identical databases. We
% threw together the script and decided to just delete the record and re-insert
% it with the data that was brought into sync. Now the question: Is it just as
% fast to do it this way, or is there some hidden advantage to performing an
% update?

If you have foreign key relationships to the table being updated, then
deleting from that table will often be slower than updating.


--

Patrick TJ McPhee
North York  Canada
ptjm@interlog.com