Is your dnn site slow?

Source: Internet
Author: User
Tags dnn

After your dnn site has been running online for a period of time, you will find that the speed is declining and loading pages is slow. Why?
If you look closely, you may find that the data library is constantly expanding. I think this is the culprit of slow websites. In dnn, if you enable the website record function or a task scheduling, this will generate a pile of record information, and over time, the database on your site will continue to expand. if you have the conditions or permissions, you may want to go to host management/SQL service or execute the following statements in SQL manage to see where your database size is consumed:
Sp_spaceused EventLog/sitelog/schedulehistory

1. If the log file is too large, you can compress the log file. For more information, seeClear SQL server logs 
2. The preceding method cannot clear the data in the schedulehistory table. Run the following statement to clear the data:

Truncate   Table EventLog
Truncate   Table Schedulehistory

Truncate   Table Sitelog
Truncate   Table Searchitemwordposition
Go

 


Address: http://www.dnnsun.com/

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.