Meet the new slender tblPage

by: Per Bjurström

Back in EPiServer 4.60 when we introduced the new multilanguage support we did a lot of changes in the good old database, one of them were making a table for page languages called tblPageLanguage. This table became a subset of the main table tblPage (which contained pages and all their meta data). We realized that tblPage where used all over the place by ourselves and some tweaks existed out there made by partners(even though not supported). So we decided that tblPage for compatibility reasons should store master language data for every page(the first language created), just duplicating information from tblPageLanguage.

Now the time has come to get rid of that legacy, smaller tables implies faster tables.

Beach 2006:

tblPage_before

Beach 2008:

tblPage_after

25 March 2008


Comments

  1. Looks very nice!

    Is this for SP2, R2 or later?

    /Fredrik

  2. R2
Post a comment    
User verification Image for user verification  
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