In my app we have some methods where we start it by selecting a whole bunch of information (in DB), compute a lot of of things and then fire some save commands to update this new information in DB.
Well my question is what to choose when I have 2 options:
1) to query a huge SELECT command joining all needed tables all at once. Then all information I might need would be brought in this select.
2) to select the main table and then in each step of the iteration, based on what I really need, I go selecting information in other tables, passing the IDs I brought in the main table.
Why would I choose one or the other What is more performatic
I am using an ORM, which, for the moment, does not work directly with joins, so if this would be the case (joins) I would have to write a custom query to it...