Hi Matt.
My guess is that Mezzanine’s Page middleware tries to fetch a page on every
request (as pages can have any URL). I would try to disable the middlewares you
don’t need and see if that works.
From: Matt Mansour
Sent: Wednesday, July 24, 2019 10:05 AM
To: Mezzanine Users
Subject: [mezzanine-users] Page and Site SQL Gets Triggered with View
LevelCaching
Hi All,
I am caching an endpoint at the view level and I noticed there are still two
sql calls being made for the Site and Page objects, after the below response is
cached .
class CampaignDetail(APIView):
@method_decorator(cache_page(10))
def get(self, request, version, campaign_key):
campaign =
Campaign.objects.select_related('product').get(campaign_key=campaign_key)
data = {
"active":"true",
"deal-price": "20.00",
"daily-limit-reached": campaign.daily_limit_reached(),
"keywords": campaign.get_campaign_keyword(),
"product-asin": campaign.product.asin,
"product-name": campaign.product.product_name,
"product-price": "{}".format(campaign.product.price)
}
return Response(data)
Campaign subclasses TimeStamped (not Displayable), so I am wondering why the
following SQL still gets called upon refresh during the cache period:
SELECT"django_site"."id", "django_site"."domain", "django_site"."name"FROM
"django_site" WHERE UPPER("django_site"."domain"::text) =
UPPER('localhost:8000')
And
SELECT"pages_page"."id", "pages_page"."keywords_string",
"pages_page"."site_id", "pages_page"."title", "pages_page"."slug",
"pages_page"."_meta_title", "pages_page"."description",
"pages_page"."gen_description", "pages_page"."created", "pages_page"."updated",
"pages_page"."status", "pages_page"."publish_date", "pages_page"."expiry_date",
"pages_page"."short_url", "pages_page"."in_sitemap", "pages_page"."_order",
"pages_page"."content_model", "pages_page"."parent_id",
"pages_page"."in_menus", "pages_page"."titles",
"pages_page"."login_required"FROM "pages_page" WHERE ("pages_page"."site_id" =
1 AND ("pages_page"."publish_date" <=
'2019-07-24T15:26:59.395377+00:00'::timestamptz OR "pages_page"."publish_date"
IS NULL) AND ("pages_page"."expiry_date" >=
'2019-07-24T15:26:59.396055+00:00'::timestamptz OR "pages_page"."expiry_date"
IS NULL) AND "pages_page"."status" = 2 AND "pages_page"."slug" IN ('api',
'api/v1', 'api/v1/campaign/a8b7ea62-79d0-4ee4-8f62-81fcde54ea32',
'api/v1/campaign')) ORDER BY "pages_page"."slug" DESC
I'd like to avoid all db hits if possible. Does anyone see what I am doing
wrong or if there is a bug here?
--
You received this message because you are subscribed to the Google Groups
"Mezzanine Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/mezzanine-users/ad008e6c-856b-466a-919e-fa407461a047%40googlegroups.com.
--
You received this message because you are subscribed to the Google Groups
"Mezzanine Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/mezzanine-users/5d388935.1c69fb81.8de47.be88%40mx.google.com.
