John, Harrison,
- Original Message -
From: "John McCaskey" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Friday, December 17, 2004 3:33 AM
Subject: Re: Relative efficiency (in terms of disk io) between REPLACE and
Ahhh, thats very good to know. Thank y
Ahhh, thats very good to know. Thank you.
On Wed, 2004-12-15 at 19:09 -0500, Harrison Fisk wrote:
> No.
>
> In InnoDB an UPDATE is done as a DELETE/INSERT internally because it
> is
> multiversioning and it has to be able to rollback in case of a
> problem.
> So the UPDATE effectively does t
Hi,
On Wednesday, December 15, 2004, at 12:51 PM, John McCaskey wrote:
On Wed, 2004-12-15 at 11:46 -0600, gerald_clark wrote:
John McCaskey wrote:
I'm currently doing a large number of REPLACE queries, I know that
these
evaluate as if doing a DELETE/INSERT pair, and I'm wondering if this
is
true
On Wed, 2004-12-15 at 11:46 -0600, gerald_clark wrote:
>
> John McCaskey wrote:
>
> >I'm currently doing a large number of REPLACE queries, I know that these
> >evaluate as if doing a DELETE/INSERT pair, and I'm wondering if this is
> >true on a disk io level as well with extra io occuring for th
John McCaskey wrote:
I'm currently doing a large number of REPLACE queries, I know that these
evaluate as if doing a DELETE/INSERT pair, and I'm wondering if this is
true on a disk io level as well with extra io occuring for the delete,
and then re-insertion, vs what would occur with an UPDATE.
Th
I'm currently doing a large number of REPLACE queries, I know that these
evaluate as if doing a DELETE/INSERT pair, and I'm wondering if this is
true on a disk io level as well with extra io occuring for the delete,
and then re-insertion, vs what would occur with an UPDATE.
The way it works roughl