Which is more efficient in heavy usage platform?
  1. Join 8 tables with billions of rows
  2. Select the "primary row" from a table then run multiple select queries on the other tables using each primary key returned from the first table in a for loop on the client side

Regards,

Cheyenne O. Forbes