3 ms·
These all seem like fine examples of solutions that are worse than the problem they were meant to solve. A separate table will be harder and slower to query and
by stdbrouw 4y ago
These all seem like fine examples of solutions that are worse than the problem they were meant to solve. A separate table will be harder and slower to query and will enable M2M relationships even when you don't want those. Sentinel values must be dealt with at every query to ensure they are always filtered out.
- mjevans 4y agoThank you for pointing that out. A better relationship would be if the order_suppliers table was the one with a relation to this table and there wasn't even a column.