I have a two tables with 1:1 relationship, one table is called
questions with 14 fields and the other is called
links with 3 fields, the foreign key is in the question table. The tables are both MyISAM.
In the links table the fields are: linkId, questionUrl and count
The reason for having the links table is that I can track clicks each time a user clicks on a link it increments the corresponding row.
Am I correct to leave this, or move the 3 fields from the links table to the questions table? My reasons for having a separate table is because the links table will be accessed and updated a lot more (each time any link is clicked).
Are there any performance issues or caveats for either?