Product query is always fetching from DB instead of cache

[pbadveliea305c]

Dear Community members,

I have observed  while calling Magento Product query using Graphql every time it's going to the DB to fetch the products although internally Magento is using product collection. Need to understand why COLLECTION_DATA cache is not working for this.

It's mentioned in devdocs that it caches the collection but seems like it's not. 

Can someone please support if I've to do some manual configurations to make it working as cache: status is giving me all the caches enabled.

Please note my FE is headless that's why using Product query.

Thanks,

Prasanthi B

[Ankit Jasani]

Hi @pbadveliea305c ,

I have faced similar issue earlier but at that time in my case cache management graphql cache disabled. After I enabled from backoffice I noted product specific graphql generating cache tags like cat_p_1, cat_p_2, cat_p_3 for the first time when cache not available inside var/cache

Once its generated graphql is serving data from cache tags.

Please also validate by checking if any custom extension is explicitly setting graphql cache to false from schema.graphql, as this could prevent proper caching and cause the issue.