Blog entries posted during 2017

  • A curious case of SQL execution plan

    I said this, and I will repeat it here: SQL Server optimizer is smart, and in most of the cases, it’s smarter than you and me (I have no doubt that you are smart, even very, very smart 🙂 ). So most of the case, you leave it to do whatever it thin...

  • Announcing Order extension for ServiceAPI

    ServiceAPI has been a popular RESTful APIs for Episerver Commerce, and it has been used by many websites, allowing easy and reliable integration with external systems. However up until now, only Catalog-related APIs (and a small set of CMS asset a... 2

  • Episerver Commerce catalog performance optimization – part 4

    Recently I worked on a support case where a customer reported deadlocks and timeout exceptions on queries to a specific table – NodeEntryRelation. Yes, it was mentioned in this post. However, there is more to it. Keeping the indexes healthy...

  • Reindex obsolete prices in Episerver Commerce

    Recently I stumped upon this question: http://world.episerver.com/forum/developer-forum/Episerver-Commerce/Thread-Container/2017/8/event-for-price-becoming-validinvalid/ which is very interesting to me. I can see this is a real scenario – and even...

  • Maintaining your indexes

    Indexes are crucial to SQL Server performance. Having the right indexes might make the difference of day and night with your application performance – as I once talked here. However, even having the right indexes is not everything. You have to kee...

  • Permanently drop prices of all products

    This is an unusual post – as I usually don’t post sample code – that should be the job of the documentation. However, I jumped upon this question http://world.episerver.com/forum/developer-forum/Episerver-Commerce/Thread-Container/2017/8/global-pr...

  • Watch out for orphan rows in Episerver Commerce database

    One of the most important aspect of data storage is integrity, meaning that the accuracy and consistency is maintained throughout the life cycle. However, there are cases when the integrity can be compromised in certain tables. It is difficult (if...

  • Episerver Commerce commandTimeout configuration

    We at Episerver takes performance seriously – as one of the feature that constantly monitored and fine-tuned. This is especially true for database accesses, as they are usually the bottlenecks of the system (accessing databases are I/O operations...

  • Episerver caching issue with .NET 4.7

    If you are using Episerver and update to .NET 4.7 (even involuntarily, such as you are using DXC/Azure to host your websites. Microsoft updated Azure to .NET 4.7 on June 26th) , you might notice some weird performance issues. If your servers are i...

  • Price optimizing: to be or not to be

    It can be quite confusing when you first edit prices in Episerver Commerce. To your surprises, some of the prices you imported or edited might disappear, or change, without your consent! What happened? To answer that question, it’s essential to kn...

About the blogger

Quan Mai


Episerver AB
Oracle

Episerver Commerce software engineer. Author of Pro Episerver Commerce.