MYSQL JOIN Query Vs PHP loop query Performance

Question

I have working on two way to fetch datas from multiple tables.

Can you provide the idea of which one work faster?

Thanks in Advance.

Possible duplicate of MySQL query in a loop vs using a SQL join — AymDev
– AymDev, Commented Jul 17, 2018 at 10:00
1/ We have no idea how your data looks like, 2/ We have no idea how many data you have, 3/ Can you please show us an example of what you tried? The best way is to test it yourself so you will have an idea of what's faster ! But the less you send request to your database, the better it is I think. Send ONE query with some join is better than sending thousand of query in a foreach loop — Mickaël Leger
– Mickaël Leger, Commented Jul 17, 2018 at 10:01

Rick James · Accepted Answer · 2018-07-18 01:58:01Z

3

If SQL can do the task, it can usually do it faster. Reasons:

Not shoveling data between client (PHP) and server (mysqld).
Not having to parse and optimize multiple queries.
More optimization tricks that you might not think of. (The flip of this is that you might not have the best indexes, etc on the queries.)

answered Jul 18, 2018 at 1:58

Rick James

144k15 gold badges144 silver badges255 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1