how to prefetch comments in django

Question

class Comment(models.Model):
parent_comment=models.ForeignKey(
    to='self',
    related_name='_comments',
    on_delete=models.DO_NOTHING,
    null=True,
    blank=True,

how to prefetch _comments: child_comment The deeper the depth, the deeper the N+1 query problem

Answer 1

I couldn't find anything doing prefetch, so I decided to change the logic eventually. I got the first comment and made a comment that mentions it

If you have any other good content, please let me know!

parent_comment = models.ForeignKey(
    to='self',
    related_name='replies',
    on_delete=models.SET_NULL,
    null=True,
    blank=True,
)
replied_comment = models.ForeignKey(
    to='self',
    related_name='mentions',
    on_delete=models.SET_NULL,
    null=True,
    blank=True,
)