example of query with joins that affect performance

02 orm_data_model_example.py

class Reporter(models.Model):
    id = models.AutoField(primary_key=True, null=False)
    name = models.TextField
    
class Article(models.Model):
    id = models.AutoField(primary_key=True, null=False)
    content = models.TextField(null=True)
    reporter = models.ForeignKey(Reporter, on_delete=models.CASCADE)
   
ids = [a.reporter.id for a in Article.objects.filter(content__contains="camelCase")] # 1
ids = [a.reporter_id for a in Article.objects.filter(content__contains="camelCase")] # 2

query = '''
SELECT R.id
FROM article AS A
INNER JOIN reporter AS R
ON A.reporter_id = R.id
WHERE content like '%camelCase%'
'''
query = '''
SELECT A.reporter_id
FROM article AS A
WHERE content LIKE '%camelCase%'
'''