EPiServer CMS 5 R2 introduces a bunch of database performance optimizations related to classic page functionality such as load, save, delete, empty wastebasket, loading dynamic properties, simple address etc. Fixes include table changes, stored procedure updates and new indexes.

We also removed some older columns/tables that was only used for backwards compatibility, for example by cleaning up tblPage.

This graph displays time taken to create a page when generating 100,000 pages. The red line is R1 where time taken keeps increasing fast as the number of pages increases. The blue line is R2 which maintains performance much better throughout the complete pass.

All tests performed on 64 bit versions of SQL Server 2005 and 2008 on our lab servers.