Blog entries posted during 2017

  • Optimizing a count

    This is a continuation of my previous post about paging in SQL Server. When it comes to paging, you would naturally want to know the total number of rows satisfying, so you can display some nice, useful information to your end-users. You would...

  • The art of paging

    No this is not really “art” – I’m just trying to have a more clickbait title. It’s more about understanding what you have at your disposal and use them for your benefits – in this case – how new SQL statement can drastically improve your...

  • Fixing a stored procedure

    At Episerver development team, we understand the importance of good performance. Who would not like a lightning fast website? We work hard to ensure the framework is fast, and we seize (almost) every opportunity to make it faster. You know in...

  • Lessons learned from a “boring” Black Friday

    This Black Friday, I was in a task force, ready to help high profile DXC Commerce customers to cope with a peak in traffic. It turned out to be boring – there was no moment I could be a hero and “save the day”. Things went surprisingly smooth, eve...

  • Please, rebuild your database indexes, now

    I will make it quick and to the point: if you are expecting a lot of customers visiting your site tomorrow (and you should) for Black Friday, you should rebuild your database indexes, now. On average, it will help you to serve more customers and...

  • Read only Catalog UI – part 1

    https://world.episerver.com/forum/developer-forum/Episerver-Commerce/Thread-Container/2015/6/read-only-catalog/ A while back, we had this question on World. It’s not uncommon to update the catalog data by an external system, mostly from a PIM –...

  • Beware of IContentLoader.GetChildren()

    This is more of a self-to-note. If you are using IContentLoader.GetChildren<T>(ContentReference), one important thing to remember is this uses the current preferred language. Normally when you get children of a catalog, or a node, that would not b...

  • Super charged Episerver Commerce performance

    Well, that was the title of my talk at the last week Meetup in Lund – hosted by Avensia. My first time in Lund – it was a very nice (even small city). It was a very nice event with about thirty developers from inside and outside Avensia, and I hop...

  • A curious case of SQL execution plan, part 2

    Recently I wrote about how to look into, identify and solve the problem with a SQL Server execution plan – as you can read here: http://vimvq1987.com/2017/10/curious-case-sql-execution-plan/ I have some more time to revisit the query now, and I...

  • 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...

About the blogger

Quan Mai


Episerver AB
Oracle

Episerver Commerce software engineer. Author of Pro Episerver Commerce.