I thought I understood outer joins but was struggling with one and watched this video to go "back to the basics." Problem solved! Very clear explanation. Many, MANY thanks for putting together this very helpful video!
I don't think I agree with your statement at 16:00. What if all Users individually owned all Products? Then each User will have 2403 rows in the joined table, amounting to a joined table of 1802*2403 => 4330206 rows which is obviously greater than 2401
I've just started watching your video and at 0:55, you join *user* as singular but then in the where clause you use *user* as plural. Man I've wasted my whole day trying to figure out how to use this stuff. What a frustration! Thank you for the video.
Those times are only spent in the database and not total times, so you would have to account for us creating the user object in ruby and then making another call, this would be closer to actual app time: If youtube wasn't so lame they would let me paste the benchmarks: gist.github.com number: 3185168 Join is just another tool in your toolbox, profile your app in production and optimize based on that.
So i've been struggling with joins for the past 24 hours or so, and this video absolutely helped me more so than anything else
i know it's kinda randomly asking but does anyone know of a good website to stream newly released tv shows online?
@Antonio Chris Try FlixZone. You can find it by googling :)
I thought I understood outer joins but was struggling with one and watched this video to go "back to the basics." Problem solved! Very clear explanation. Many, MANY thanks for putting together this very helpful video!
Thank you so much. It was a great session.
I don't think I agree with your statement at 16:00. What if all Users individually owned all Products? Then each User will have 2403 rows in the joined table, amounting to a joined table of 1802*2403 => 4330206 rows which is obviously greater than 2401
I've just started watching your video and at 0:55, you join *user* as singular but then in the where clause you use *user* as plural. Man I've wasted my whole day trying to figure out how to use this stuff. What a frustration! Thank you for the video.
""that's all for today, thank you for *joining* me " kekekekekek
which is gem you are using to show those SQL logs in console. ?
type rails c in console and thanks me if you are alive
@@ossama-khan ahahahah
Those times are only spent in the database and not total times, so you would have to account for us creating the user object in ruby and then making another call, this would be closer to actual app time:
If youtube wasn't so lame they would let me paste the benchmarks: gist.github.com number: 3185168
Join is just another tool in your toolbox, profile your app in production and optimize based on that.
ISBIT.MX