Huge perf enhancement to GetByQuery on the content repo, so much more like this is easy to fix with massive benefit. For example, the Retrieving_All_Content_In_Site used to run for 143795ms and now runs at 14249ms which is 90% savings.
Updated the ContentTypeRepository PerformGet method to map all property groups and types in a single query and added test to test the query, this reduces the lookup by about 30% but still lots of improvements to be made.
Fixes performance for Get(id) on ContentTypeRepository = much faster now, now to work on getall/query
Fix up right join query to use a proper select and left join (less confusing), fix up getall call when getting a content type, reduce another query and include child ids in the main query.
Updates the GetAll of ContentTypeRepository to use the new mapper which no longer executes one by one this means far less queries, updates GetByQuery to get all int ids and then use GetAll
Created new field in cmsContentType and related models for storing the configuration for a container doc type; implemented configurable page size
Refactored content and media type controllers to have inherit from a common abstract class, that implements the retrieval of the container config
Amend of container page size from structure tab of document type editing screen
Only save container config if provided
Ensured that the default container options are used if no configuration has been defined
Store, retrieve and use default order by and direction for list container document type
Changed selection of default order by column for container document types to drop down list
Store and retrieval of flags for allowing bulk publish, unpublish and/or delete on container doc types
Display or otherwise the bulk action buttons (publish, unpublish and delete) according to the container config
Set up headings with localization for container list view custom columns
Refactor of ContentTypeContainerConfiguration to use a collection instead of multiple delimited strings
Formatting of dates in list view
Prevented and removed visual indication of sorting by custom columns
Improvements to UI for selecting additional columns for container list view
Localisation of container config fields; applied sortable to list of additional columns