[Resolved] [Resolved] mysql efficiency question

[Fuzzio]

At the moment in my database I have 2 tables, lets call them X and Y.

Table X contains 4 fields:
ID | Y ID | Username | Password

Table X will need to be accessed and modified frequently. "Y ID" is like a reference to the ID of a row in table X.

Table Y contains 12 fields:
ID | and 11 other fields relating to user information

Table Y will need to be accessed and modified a lot less frequently than Table X.

My question is, should I just merge the two tables together? Or would it be more efficient to keep them how they are.

[mrhappiness]

do you have exactly one entry in table Y for every entry in table X?

if yes, than merge those two tables