Unanswered: # of queries executed vs execution time?
Say I have 2 applications that do that exact same thing on the front end, except for the queries that they run on the backend.
The 1st one runs just 1 big query to gather all the info and it takes 5 seconds.
The 2nd runs 30 smaller queries to gather the same info but it takes less time, say 3 seconds.
Is there an issue with running way more queries if it has a faster execution time compared to 1 or 2 larger queries?
I usually go the route of trying to execute fewer queries, but I'm starting to question myself.