phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Cheyenne Forbes <cheyenne.osanu.for...@gmail.com>
Subject Requests in for loop vs joins
Date Thu, 25 May 2017 15:12:30 GMT
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

Mime
View raw message