These two versions are for both the Rails 2.3.x and Rails 3.0.x branches respectively. Their primary goals were to improve the performance of the CMS, especially for larger sites (i.e. thousands of pages/files). The most noticeable improvements should be on the Sitemap, as well a viewing pages and the content library.
Thanks to the Ancestry gem, plus some better use of indexes, the number queries for pages has been significantly reduced. A special thanks to the maintainers of the Query Reviewer project which proved quick useful for benchmarking and verifying that adjustments were in fact, making things faster.
Sitemap - This page should scale considerable better than it was before. While the entire site is site still loaded, its actually done in total of 9 queries (regardless of how many pages there there are).
- Viewing Pages - Uncached pages that use dynamic menus should perform better now.
- Content Library - The core CMS library pages like Html, Images, Files and portlets have been optimized to avoid unnecessary database queries and should be faster.
- Reasonable Indexes - A good number of reasonable indexes have been added based on sample data from actual sites. Each index added was based on confirmation using EXPLAIN to make sure it actually did something (to avoid adding pointless indexes).
Depending on the version you are currently running, you can follow the upgrade instructions for: