Optimize database performance

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.

Increase your Sitefinity skills by signing up for our free trainings. Get Sitefinity-certified at Progress Education Community to boost your credentials.

Get started with Integration Hub | Sitefinity Cloud | Sitefinity SaaS

This free lesson teaches administrators, marketers, and other business professionals how to use the Integration hub service to create automated workflows between Sitefinity and other business systems.

Web Security for Sitefinity Administrators

This free lesson teaches administrators the basics about protecting yor Sitefinity instance and its sites from external threats. Configure HTTPS, SSL, allow lists for trusted sites, and cookie security, among others.

Foundations of Sitefinity ASP.NET Core Development

The free on-demand video course teaches developers how to use Sitefinity .NET Core and leverage its decoupled architecture and new way of coding against the platform.

Was this article helpful?

Next article

Force pages to compile