|
I'm creating a PHP/MySQL based website dealing primarily with students. One of the pages shows staff members a student's profile and this data is retrieved from a number of tables, at least 7 at the moment. The main students table contains mostly keys to rows in the other tables. I have 2 options for getting the required data, either one big query full of joins or multiple queries, the results of which are then processed with PHP. In a client/server application, rather than keeping this PHP and MySQL specific, which option would generally be better? In the case of readability, multiple queries might be better but what are the other pros and cons of each option?
|
# ¿ Jan 9, 2008 13:35 |
|
|
# ¿ May 3, 2024 16:32 |