News for hackers. Stuff that matters.

A comment on Cost of a Join. Parent comment

Re:Cost of a Join by thaumaturgy on Tuesday August 14, 2018 @07:20PM (#17762731)
In MySQL at least, removing enums from a list requires running some expensive `alter table` operations.

It's fine for lists where the possible values definitely, absolutely, for sure won't change, but for things like attributes on elements of a set, enums are evil.

[ Parent | on HN ]
Re:Cost of a Join by jjeaff on Tuesday August 14, 2018 @07:26PM (#17762750)
But it's just removing that causes the problem. Which doesn't seem like an important feature. I almost always keep old values for historical purposes/backwards compatibility with backups.

You can add values without issue.

[ Parent | on HN ]