Slide 40
Slide 40 text
Limiting what you are selecting
However, in menu, we only display name; we only need id & campaign_id
for the link. So, the query should be:
@louisemeta
1
2
SELECT "ad_analytics_ads"."id", "ad_analytics_ads"."name",
"ad_analytics_ads"."campaign_id", "ad_analytics_ads"."image",
"ad_analytics_ads"."target_url", "ad_analytics_ads"."impressions_count",
"ad_analytics_ads"."clicks_count", "ad_analytics_ads"."created_at",
"ad_analytics_ads"."updated_at"
FROM "ad_analytics_ads" WHERE "ad_analytics_ads"."campaign_id" IN (...)
1
2
SELECT "ad_analytics_ads"."id", "ad_analytics_ads"."name", "ad_analytics_ads"."campaign_id"
FROM "ad_analytics_ads" WHERE "ad_analytics_ads"."campaign_id" IN (...)
By default, Django ORM selects all columns.
When we do prefetch_related, here is the query: