Database experts, should I use a separate query or a subquery? π€
For example, I want to retrieve the author's name for all the posts. Should I add a subquery to fetch that name, or use a separate query to get the names and then map them with the posts? π§
neither nor. use joins within your query.
- have you considered primary and foreign keys in the database schema?
Basically if we talk about laravel then it was
with() vs withAggregate().
First case $post->author->name and 2nd case $post->author_name π§
Well depends on the context
I would go with seperate queries. If the seperate model needs to be used somewhere down the line.
Otherwise I would go with joins
For small database we can use joins.
For large data you want to Denormalise and make separate queries, you can partition , you can even keep data in separate databases, maybe you can keep 1 part of the data in cache which relatively changes less.
Make it complicated π
- Create a new col in post with author name
- Add auto update when author model change in a async queue
After that, u can own a lambo π
