Members and Studies application
Posted: Sun Jul 18, 2010 3:42 pm
Hello. I have a question.
I am making an application that shows if some "members" have done some "studies". There are 50 set studies. This is the way I have it set up:
3 Tables --->
Member:
member_id, member_name
Studies:
study_id, study_name
member_studies:
member_id, study_id, teacher, comments, date
In the "member" table I actually have about 50 other fields, I just didnt put them because they were not needed. My concern is, because I have more than 1000 members, If I want to know how many people did for example the "study 1" then, It will do a search through all the ones that have the study_id = 1, then check which name is to the "member_id" and which study_name goes for the "study_id". My problem is that I think that would take a long time. Is it better if I just put those fields for each lesson in the "members" table (the problem with that one, is that I will have more than 200 fields). I dont know If everything is clear, but please let me know if its not, thank you.
I am making an application that shows if some "members" have done some "studies". There are 50 set studies. This is the way I have it set up:
3 Tables --->
Member:
member_id, member_name
Studies:
study_id, study_name
member_studies:
member_id, study_id, teacher, comments, date
In the "member" table I actually have about 50 other fields, I just didnt put them because they were not needed. My concern is, because I have more than 1000 members, If I want to know how many people did for example the "study 1" then, It will do a search through all the ones that have the study_id = 1, then check which name is to the "member_id" and which study_name goes for the "study_id". My problem is that I think that would take a long time. Is it better if I just put those fields for each lesson in the "members" table (the problem with that one, is that I will have more than 200 fields). I dont know If everything is clear, but please let me know if its not, thank you.