Skip to main content

Got RAM?

I remember my first experience with .Net Framework and C# after years of MFC/COM/DCOM torture with lovely C++. Whoa, I don't have to track every reference and resource allocation? That GC thing rules! No more memory leaks! Right...

Let's say, you're tasked with integrating Sitecore Commerce 9 and some PIM. It totally makes sense to use the Sitecore Commerce catalog system, so your integration would imply importing catalog structure and contents from PIM. While API capabilities of PIMs may vary, pretty much every type of PIM supports file exports of catalog. The native Sitecore Commerce catalog import/export is still in its infancy (no support for partial, incremental, or selective operations, not to mention lack of converters into its pretty unorthodox format, as well as inability to import product assets), so your only option is to build a custom catalog import plugin. The code for creating catalogs, categories and sellable items is relatively well-known and somewhat documented, so there should not be any surprises. You create a minion that watches for new PIM exports and consumes them. Everything is very straightforward. You create pipelines for updating categories, products, variants, and corresponding relationships. In order to perform operations with entities, you need instances of commerce commands. IoC takes care of that for you with something like this:


OK, now you can iterate through the new categories and use this command to create them in catalog. For example:


Easy! And it works just fine in tests. However, when you decide it to run against your full catalog with dozens of thousands categories, the Commerce Engine suddenly starts eating up gigabytes of your precious RAM. How could that be even happening? Moreover, memory gets eaten much faster if you use several commerce commands within the same pipeline block - for example, CreateCategoryCommand, AssociateCategoryToParentCommand, EditCategoryCommand, DeleteCategoryCommand, and DeleteRelationshipCommand for the full category synchronization package.

All commands in Sitecore Commerce 9 derive from the Sitecore.Commerce.Core.Commands.CommerceCommand base class, which in turn contains Models property:


Every time a command is used, this property gets populated by CommandActivity with the full instances of the entity models that were affected by that command. This includes versions, localizations, and such entity types:

Eventually a poor command ends up with hundreds of thousands hefty models in its Models property. This is a common architecture approach - to collect data updates and write them in a single batch before the disposal of the command object thus reducing number of calls to the database. However, it does not exactly work with huge number of updated entities. I'd like to think that Sitecore is planning on implementing some kind of collection monitor that would drain the Models list once it reaches a certain size. For now (as of Commerce 9 Update 3) that is your responsibility. While it might look like a bad design decision from the performance point of view, instantiating a new command before each use made import considerably faster. Don't forget, you can always do it using the CommerceCommander:

Of course, you can improve performance even further by creating a new command after each 100th, 1000th, or 10000th use. Just watch your RAM...

Comments

Popular posts from this blog

SharePoint 2013 and "search scopes"

While SharePoint 2013 introduced some undeniably handy features in the content discovery department, some of the old functionality has changed so much that you'll have to forget many of the design tricks that worked in 2007 and 2010.  One of such pain points is deprecating search scopes in SharePoint 2013. The requirement Let's start with a trivial situation. You have a requirement that states: "A user should be able to perform different types of search from any page/sub site on the portal by selecting a type of search and specifying keyword(s)". This would be considered an out-of-box functionality in 2007/2010: you just enable search scopes dropdown (considering the search box control is already in the master page), and define scopes. Piece of cake! Well, not so much in 2013.   The problem The thing is - there's no search scopes in SharePoint 2013. OK, to be exact - there's no user-definable search scopes, as we still have a couple of built-in

What's in your cart?

Let's say, you've added product A to your shopping cart. Then you get back to the product details page and add product A again. What's going to happen? You will still have one line in your cart, but the quantity of product A will be equal two . This is a standard behavior of B2C shopping carts, including the Sitecore Commerce 9 ones. Now, imagine that your business processes require a bit more complicated scenarios, where you might want to actually create two lines in the cart, and avoid rolling them up into a single one. It is much more common than you might think. For example, you are buying two toasters of the same make and model, but you want only one of them gift-wrapped. Or you buy two pairs of glasses belonging to the same SKU, but you want to specify different prescriptions for them. Obviously, you do not want to roll them up under a single cart line. What does Sitecore Experience Commerce 9 provide you with in order to handle such scenarios? Let's take

Navigation Settings in SharePoint 2013 Site Definitions

Who likes creating SharePoint site definitions from scratch? Well, it's not my favorite part of the SharePoint development either. An initially good idea of setting up your whole site through an XML file, received implementation and support far from being perfect. That quickly lead developers to look for alternative ways of defining and provisioning sites, primarily through the SharePoint API. A simple ONET.XML with beefy code-packed features became de-facto standard. What was supposed to be a template became compiled code. I was hoping SharePoint 2013 would at least attempt to do something about it… Tasked with creating a few publishing portal site definitions, I was unpleasantly surprised to find out that any attempt to use my new site definition to provision a site collection root results in both Global and Current Navigation switched to "Managed Navigation" mode, while I needed it to stay in the good old "Structural Navigation" one. This mode is new to Sh