3 ms·
Joins don't scale to more than one relation. Modify the original sample to load two relations: fetch all events with their first 5 categories and all their use
by imtringued 7y ago
Joins don't scale to more than one relation.
Modify the original sample to load two relations: fetch all events with their first 5 categories and all their users.
If you use two joins then you get a combinatorial explosion because you are now getting all permutations of the (event, category, user) tuple.
(event1, category1, user1)
(event1, category1, user2)
(event1, category2, user1)
(event1, category2, user2)