I have some data that I need to access via a select query. However to get at it, I wold need to do about 4 inner joins on an id.
It is certainly simpler to just plug in one or two fields that are then repeated elsewhere in the database at the point of data entry (they are readily accessible at the point of data entry in the form of a php array).
However I worry that this means that the same fields (data) will be replicated in different tables.
However the select seems a lot simpler than a deep dive join between four tables on an id.
Is that a big no no? Is the select more efficient than a highly complex join?