Blog entries tagged with EPiServer CMS 5 R2

LOOP JOIN and other fun query optimizations

by: Per Bjurström

Consider this SQL Server query that is part of EPiServer CMS 5:SELECT tblPageLanguage. fkPageID, tblLanguageBranch. LanguageID as LanguageBranch FROM tblPage JOIN tblPageLanguage ON tblPage. pkID=tblPageLanguage. fkPageID LEFT... [ Read full article ]

26 March 2008  0 Comments

Tags:

Performance tweak: Optimizing StaticFileHandler in EPiServer CMS 5 (part 2)

by: Per Bjurström

This is a update to my previous post. EPiServer CMS 5 Release 2 will support kernel-mode response caching when you enable expirationTime on a VPP in web. config. Kernel mode response caching is handled by http. sys which is the HTTP protocol stack... [ Read full article ]

06 May 2008  2 Comments

Tags:

Automatic index rebuild script

by: Per Bjurström

To speed up access to the data in SQL Server we use something called indexes, most of you probably know all about it. Indexes are B-tree structures that are extremely efficient for looking up data, consider the fact that looking up row based on a... [ Read full article ]

04 July 2008  0 Comments

Tags:

Per Bjurström

About me

I'm a senior developer and architect on the development team in Stockholm and has been with the company since 1999. I live on Södermalm in Stockholm. My main focus areas are new technologies and how we can use them in our product development.

Messenger

Syndications

Archive

Tag cloud

EPiTrace logger