On 12/26/08 1:24 PM, 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 thing about this whole discussion that people seem to miss is that
you have to choose to use the IGNORE keyword. We are not talking about
default behavior. If you use the IGNORE keyword, you are accepting
responsibility for what happens. If someone hires a bad developer that
uses IGNORE when they shouldn't that is their fault. Drizzle can't be
everyone's police. In a language like PHP, you can ignore errors
without the IGNORE keyword by simply not checking the return value of
the mysql_query() function call. Bad programmers are bad programmers.
They are a force of nature and can not be stopped.
--
Brian Moon
Senior Web Engineer
------------------------------
When you care enough to spend the very least.
http://dealnews.com/
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
