phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Cheyenne Forbes <>
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


Cheyenne O. Forbes

View raw message