I'm trying to join two tables for
project 2 (users, history), but i
read that JOIN isn't a good practice and will eventually be bad if
your tables get larger.
so i created new tables as the following:
used a foreign key.
the question now am i on the right track?
is JOIN real problematic with larger tables?
is FK any better than JOIN?
another method my friend pointed me to but its also condusing:
he doesn't join or use a FK but he told me to use php to fill everything because table relations are slow...
I am really confused about MySQL i don't know how to design my tables. is there any reliable book or source to learn from other than the MySQL manual cause i am a beginner and the manual isn't friendly...
Thanks in advance.