Hello,
I'm working in a very high traffic generating site, (aprox. 30,000 daily visitor).
I have a two tables related with each others by an ID, it works like that: a table called lectures, and a table called speakers, so whenever I go to the page of a certain lecture, I check the speaker_id from the table lectures and get the name of the speaker from the speakers table.
Which is faster and more optimized for doing the above:
A)QUERY= mysqlquery("select lectures.lecture_name, speakers.speakers_name from speakers,lectures where lectures.speaker_id=speakers.speaker_id")
😎 or doing it into two mysql queries seperately, first quering table lectures, and then quering table speakers.
