I am having following problem:
User fills out the form, which consists of two sets of fields - header (basic information about biological observation) and detail (measurements and advanced information). It is assumed, that not every user will fill out the detailed information.
I am wondering, what is better design with respect to performance
- to have one table with all fields and those
- to have two separate tables - one for
headerand one from
detailwith 1 to 1 relation, and in case the user did not fill the detail, do not insert record into
Further information: header and detail will always be used together, so for every
SELECT statement, I would need to join them.
I suppose I could formulate the question as follows: In case of two-tables design, would the space I save make up for the slower performance (due to join)?
I am using MySQL database.