Each time a tag submission is made, we INSERT into metadata regardless of whether the metadata (for the tag) already exists. This is a bug and duplicates metadata meaning that the table grows in an unnecessary manner.
We should perform a lookup to determine whether the metadata already exists. Only perform an insert if it does not.
Each time a tag submission is made, we
INSERT
intometadata
regardless of whether the metadata (for the tag) already exists. This is a bug and duplicates metadata meaning that the table grows in an unnecessary manner. We should perform a lookup to determine whether the metadata already exists. Only perform an insert if it does not.