which is better one big query or multiple small query? [closed]
As a rule of thumb, the less queries the better.
This is a good question but this has been answered multiple times.
Is it better to return one big query or a few smaller ones?
Multiple small queries vs a single long query. Which one is more efficient?
One big query vs. many small ones?
Which one is faster single big query or few small queries?
What is faster, a big joined query with more PHP or multiple small selects with less PHP?
Should I use one big SQL Select statement or several small ones?
https://dba.stackexchange.com/questions/76973/what-is-faster-one-big-query-or-many-small-queries