As expected like Redis the clear cache is not working for the SQL server. To produce the bug configure the SQL server for caching and try to change the setting something like enabling and disabling the city and etc.
Nopcommerce should take distributed cache more seriously. Because without this feature, it is really difficult to run the shop at the distributed system.
enable sticky session is a killer for a distributed system.
The big problem is more cache has been added at 4.5, even at shopping carts and many other places have been cached. The SQL query has been cached and then the distributed cache is not working. Such a killing scenario for a distributed e-commerce. Nightmare.
Clear cache not working even with sql server distributed cache 4.5
Membro da Equipa
- 549
- 6645
- 17/12/2015
- Armenia
I suppose that we talking about this problem. Unfortunately we still waiting the changes from microsoft comand for this issue, we hope that this issue will be solve in the .Net 7
MVP
Programador certificado
- 1052
- 8801
- 12/06/2015
- Bangladesh
Sergei-k wrote:
Yes true. But do not know how other cms like Umbraco solve the limitation of the .net core. Actually the last couple of days I was trying to see the shop behavior with SQL server distributed cache and get shocked.
Till this issue has not been fixed. There is no way to deploy nopCommerce 4.5 for distributed sytem. Because the main problem is query caching and at any cost, this issue can not be resolved, except removing query caching. Even enabling sticky_session will not help us. As it is not related to the session rather query caching per instance.
In the previous version, sticky_session helps us with distributed systems, because at least we know that some sensitive data like shopping will always come from a database but query caching kill that as well.
So we have to say because of mocrosoft less feature nopCommerce4.5 can not support web-firm.
Whatever thanks a lot for answering. There is no doubt that massive improvement has been done at nopCommerce 4.5. But when it comes to a busy shop/con-current visitors. we can not depend on a single giant server.
Thanks again.
I suppose that we talking about this problem. Unfortunately we still waiting the changes from microsoft comand for this issue, we hope that this issue will be solve in the .Net 7
Yes true. But do not know how other cms like Umbraco solve the limitation of the .net core. Actually the last couple of days I was trying to see the shop behavior with SQL server distributed cache and get shocked.
Till this issue has not been fixed. There is no way to deploy nopCommerce 4.5 for distributed sytem. Because the main problem is query caching and at any cost, this issue can not be resolved, except removing query caching. Even enabling sticky_session will not help us. As it is not related to the session rather query caching per instance.
In the previous version, sticky_session helps us with distributed systems, because at least we know that some sensitive data like shopping will always come from a database but query caching kill that as well.
So we have to say because of mocrosoft less feature nopCommerce4.5 can not support web-firm.
Whatever thanks a lot for answering. There is no doubt that massive improvement has been done at nopCommerce 4.5. But when it comes to a busy shop/con-current visitors. we can not depend on a single giant server.
Thanks again.
