On Fri, 26 Dec 2008, Ann W. Harrison wrote:
> Brian, > > > > > > Alan's discussion about how MogileFS uses it made sense to me. The only time > > I have found it useful is when we were handling of merging data between > > multiple systems, where there was a possibility that their might be a > > conflict on primary key. If the data already exists... move on and don't > > worry about it. It boils down to lossy data cases. > > Err, are you going to ignore only records that are complete duplicates > on all fields, or anything that has a conflict on a primary/unique key? > If the latter, then you may well be throwing out legitimate data that > happened to have the wrong key. The original authors took that into account ;) If we have a conflict on PKID the rest of the data is identical or equivalent. If the difference would matter, we don't INSERT IGNORE. -Dormando _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
