Developer forum

Forum » Integration » Import variant directly to sql - caching

Import variant directly to sql - caching

Keld Gøtterup
Reply

We have a solution where we have a lot of data imported directly into the dynamicweb database. This works but we do have slight caching problem, new imported variants will not show up on the site until the application is recycled.
Is there a way to clear this variant caching?


Replies

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Reply
This post has been marked as an answer

Hi Keld,
it is already fixed and will be present in Dynamicweb 9.2 release. But as a workaround for now you could subscribe to the DataIntegration JobFinished notification subscriber
and try to call those from your code to clear the cache:
eCommerce.Common.Application.KillVariantGroups()
eCommerce.Common.Application.KillVariantCombinations()
eCommerce.Common.Application.KillVariantOptions()
eCommerce.Variants.VariantGroup.ClearVariantGroupsCache()
eCommerce.Variants.VariantGroupProperty.ClearCache()
eCommerce.Variants.VariantGroupOptionPropertyValue.ClearCache()

Regards, Dmitrij

Votes for this answer: 1

 

You must be logged in to post in the forum