• Commerce,  Episerver,  Performance

    Index or no index, that’s the question

    If you do (and you should) care about your Episerver Commerce site performance, you probably know that database access is usually the bottleneck. Allowing SQL Server works smoothly and effectively is a very important key to the great performance. We are of course, very well aware of this fact, and we have spent a considerable amount of time making sure Commerce database works as fast as we could. Better table schema, better stored procedures, better indexes, … we have done all of that and will continue doing so when we have the chances. (And if you find anything that can be improved, you are very welcome to share your finding…

  • gaming,  ranting,  reviews

    A super short review of Xenoblade Chronicles 2

    I’m still just 1/3 way through the game. Here’s some of my thoughts so far Hit: Gorgeous world. No it’s not the level of graphic detail of Horizon Zero Dawn, but given Switch’s processing power, the game looks absolutely amazing. Pyra is really cute (Talking about her face) Miss Pyra is overly sexualized. .Does Monolith need to let her wear a thong into battle. While it’s common in Japanese Role Playing Games (“fans service”, they said), it’s not what gaming should be. The fetch quests are really, really boring. They need to die. Looting is tedious. Too many “collection points”, too little value or interest for each of them. The…

  • Uncategorized

    Why I left Metacritic, for good.

    I’m a mediocre gamer, by any measures, but that does not defy the fact that I love playing games. Great games, only. With my very limited time and budget, I must to be very selective about the games I play. For a very long time, Metacritic is my to-go website to check if I should play a game – and I set my rules rather high: anything less than 80 is a big no-no. Less than 85 is a no, unless it’s a sequel of a game I loved so much (so I can see how the story turned out to be). More than 85 is “I’ll think about it” (when…

  • Tips

    Delete the undelete-able folder – Windows 7, 8, 10

    If you are using Windows 7, 8, or 10, sometime there are some folders appear to be super stubborn, and refuse to go away. No matter how much you try, it just can’t be deleted. It’s undelete-able. Any attempts would result in this dreadful dialog box: “Are you f*cking kidding me? This is my computer and I have the the absolute control over everything” – You said. Naturally, you would go to open the Security tab in Properties dialog to grant the permissions to everyone. Strangely, the tab is empty! In other words, there is no one granted permission to nothing. What? Why? How? The truth is quite shocking: the…

  • Tips

    Debuging React tests with Visual Studio Code

    Visual Studio Code is awesome and it is getting more and more popular in front end development. It’s great to write code, but you know what, it can be an IDE and allow you to debug your tests as well: Go to Debug/Add Configuration menu and add this setting: [crayon-5d69e29178ee9524812491/] You can see that we are invoke the react-scripts-ts command with test argument. This also means we are not limited to tests – but I’m yet to debug the normal code. Now it’s important to remember: you have to open your root folder, in most of the cases, the parent folder of src, in Visual Studio Code. This is to…

  • Catalog,  Commerce,  Episerver

    Multiple sites: Building the outgoing URLs

    In previous recipe we talked about multiple catalogs with same “UriSegment” – which we had a working implementation for incoming URL, i.e. when a customer visit a product url, we know which catalog we should choose from. But we still need to cover the generation of outgoing URL. I.e. when we link a product (For example, from a campaign page), we need to generate an URL which take the “catalog-less” pattern into account. We need to understand how the outgoing URL is built. The hierarchical router builds the URL by the RouteSegment of contents. However, we want to the urls appear to have same catalog, so the RouteSegment part for…

  • Catalog,  Commerce,  Episerver,  Tips

    Multiple catalogs with same url

    This is an excerpt from my second book . The first chapter is available to read for free. A business is having an Episerver Commerce instance with multiple sites and multiple catalogs set up. They want to make sure each site will use one catalog, and all of them will share the same url for catalog structure. So it’ll be “https://site-a.com/products/category/”, and “https://site-b.com/products/category/”. Site A and site B are using different catalogs. Is this doable? Yes! It’s just a matter of magic with the routing. This time, we would need to do an implementation of HierarchicalCatalogPartialRouter ourselves. First, let’s create a template for it: [crayon-5d69e2917985a352504527/]

  • CMS,  Episerver,  IIS

    Adding backslash ending to your URLs by UrlRewrite

    It’s generally a best practice to add a backslash to your URLs, for performance reasons (let’s get back to that later in another post). There are several ways to do it, but the best/simplest way, IMO, is using UrlRewrite module. In most of the case, processing the Urls before it reaching the server code will be most effective, and here by using UrlRewrite we trust IIS to do the right thing. Our application does not even need to know about it. It’s also a matter of reusable. You can simply copy a working, well tested rule to another sites without having to worry much about compatibility. Before getting started, it’s worth…

  • gaming

    Is PlayStation 4 Pro a worthy upgrade?

    PlayStation 4 Pro was a first “mid-gen” upgrade in a very long time. It is an incremental update to the original PS4, keeping the promise of backward compatibility, at the cost of limited power jump. Is it a worthy upgrade? I got my original PS4 3 years go and that was a massive jump from my previous Xbox 360 (of course that is expected, it’s a different generation). Builtin hard drive, builtin WiFi N, builtin gigabit LAN, builtin Blu-ray drive, the list goes on and on. Needless to say, I have been very happy with my PS4. When Pro came out, I was a little disappointed. No UHD Blu-ray. Unable…

  • IIS,  Tips

    Fixing HTTP Error 500.19 – Internal Server Error

    When you are trying to setup an IIS website on your local machine/new server, it’s very likely that you are going to get this error HTTP Error 500.19 – Internal Server Error The requested page cannot be accessed because the related configuration data for the page is invalid. Detailed Error Information: Module    IIS Web Core Notification    Unknown Handler    Not yet determined Error Code    0x8007000d Config Error Config File    \\?\C:\EL\EL\CMS\web.config Requested URL    http://el:80/ Physical Path Logon Method    Not yet determined Logon User    Not yet determined Config Source: [crayon-5d69e2917a491029566339/] More Information: This error occurs when there is a problem reading the configuration file for the Web server or Web application. In some…