Level 63
I don't think that there is any real performance difference between both solutions.
I would rather use a polymorphic relationship.
Mar 24, 2023
1
Level 3
One-To-Many Polymorphic vs two relationship columns
Imagine you have a Post model, a Video model and a Comment model similar to the One-To-Many Polymorphic relationship in the docs. Is it better for performance to keep the One-To-Many relationship,
or
is it better (performance wise and good practice wise) to add two columns for post_id and video_id in the comments table as foreign keys and nullable?
Please or to participate in this conversation.