When publishing modified pages, or performing synchronization, it is possible that you experience degrading performance during the process due to fragmented database space. This may result in slow inserts of new data in the database and slow read times during publishing.
To avoid fragmentation of the database indexes and to improve write performance and scalability of the Microsoft SQL Server, Sitefinity CMS uses sequential GUIDs for database records' IDs where applicable. For more information, see Site synchronization key.
In addition, you can rebuild the database’s clustered indexes on a regular basis to maintain the database, optimize its performance, and avoid fragmentation of the clustered indexes.
RECOMMENDATION: Enable the database maintenance option in Sitefinity CMS or manually rebuild database indexes. For more information, see Database configuration.
Back To Top
To submit feedback, please update your cookie settings and allow the usage of Functional cookies.
Your feedback about this content is important
Copyright © 2021 Progress Software Corporation and/or its subsidiaries or affiliates.
All Rights Reserved.
Progress, Telerik, Ipswitch, and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S. and/or other countries. See Trademarks for appropriate markings.
Powered by Progress Sitefinity