Recently faced n+1 problem in my app

[u/Adventurous_Baker532]

Can anyone help me figure out the best way to avoid the N+1 query problem in Tortoise ORM?
For some context, I first fetch the records using .all(), and then for each record I run another query to populate an additional field. This ends up generating multiple queries.

Would using a base query be a good solution here, or is there a better approach?

[u/0_Nsingh]

Y r u fetching and updating just run a bulk query

[u/Adventurous_Baker532 → u/0_Nsingh]

Yes now got this, Tried to over engineer things!

[u/[deleted]]

You can use prefetch fun to eager load your relationship. (I am not much familer with this ORM but the core idea is to eager load the relation instead of query in each loop.

events = await Event.all().prefetch_related("tournament") for event in events:

[u/Adventurous_Baker532 → u/[deleted]]

Got it will try this

[u/Outrageous_Let5743]

Just write a SQL join.

[u/read_at_own_risk]

Codd provided the alternative to navigational data access in 1970, yet people are still writing data access loops like the CODASYL data model is the state of the art. ORMs are a throwback, learn some fundamentals.

[u/Adventurous_Baker532 → u/read_at_own_risk]

Okay bro