Thanks Eduardo. I'll give it a try. On Wed, Jul 24, 2019 at 9:37 AM Eduardo Rivas <[email protected]> wrote:
> 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 <[email protected]> > *Sent: *Wednesday, July 24, 2019 10:05 AM > *To: *Mezzanine Users <[email protected]> > *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 > <https://groups.google.com/d/msgid/mezzanine-users/ad008e6c-856b-466a-919e-fa407461a047%40googlegroups.com?utm_medium=email&utm_source=footer> > . > > > > -- > 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 > <https://groups.google.com/d/msgid/mezzanine-users/5d388935.1c69fb81.8de47.be88%40mx.google.com?utm_medium=email&utm_source=footer> > . > -- 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/CALizMdM_JgQsuzJkASxYvqHuEqPrbTD76OBSu0uvL1261JDh6g%40mail.gmail.com.
