[Solved] mysql multiple queries or foreign keys (table relations) [closed]

Question

Usually It depends on how frequently you fetch which columns from multiple tables.

1.If you create many foreign keys in a table and then connect with these keys to many others then you will end up joining many tables to fetch required data.

2.So I suggest you first decide what type of data you are mainly looking from this main table and how frequently you use it.

3.Also you need to create indexes on all joining keys in order to achieve better performance.This is in one way overhead and in other way saves you time.

So it all depends on your needs.

Accepted Answer

Usually It depends on how frequently you fetch which columns from multiple tables.

1.If you create many foreign keys in a table and then connect with these keys to many others then you will end up joining many tables to fetch required data.

2.So I suggest you first decide what type of data you are mainly looking from this main table and how frequently you use it.

3.Also you need to create indexes on all joining keys in order to achieve better performance.This is in one way overhead and in other way saves you time.

So it all depends on your needs.