0

According to this link, i came to know that sub select is far better than or somewhat better than joining multiple tables and comparatively better than using small queries.

And according to this link the answer seems to be for laravel 4.

Is sub select queries great in performance when it comes to laravel 5.x?

If so how may i use it on join queries in a feasible and efficient way?

HexaCrop
  • 3,863
  • 2
  • 23
  • 50
  • 1
    My advice regarding Laravel and MySQL is to just focus on what is optimal from a MySQL point of view, at least for queries. Correlated subqueries (an alternative to a join) usually do _not_ perform as well as their corresponding joins. – Tim Biegeleisen Apr 08 '19 at 05:31
  • right now i use join's. But after the articles i mentioned i am thinking otherwise since it has a valid point – HexaCrop Apr 08 '19 at 05:39

0 Answers0