Due to version compatibility and other reasons, the index of dedecms is a bit messy. If the index is set appropriately, the generation speed of dedecmsHTML is affected, it is mainly used to obtain the list of articles not sorted by default. Due to the need to re-sort the list, the speed of large data volumes is not ideal. You can perform the following steps to easily optimize the list:
1. Go to phpmyadmin and delete the dedecms site dede_archives except the index of the ID Primary Key;
2. Use SQL to create the following indexes:
Alter TABLE 'dede _ archives 'add index'click' ('click ');
Alter TABLE 'dede _ archives 'add index 'typeid' ('typeid ');
Alter TABLE 'dede _ archives 'add index 'arcrank' ('arcrank ');
Alter TABLE 'dede _ archives' add index 'sortrank' ('sortrank ');
Alter TABLE 'dede _ archives 'add INDEX 'senddate' ('senddate ');
Alter TABLE 'dede _ archives 'add INDEX 'pubdate' ('pubdate ');
Alter TABLE 'dede _ archives 'add INDEX 'litpic '('litpic ');
Alter TABLE 'dede _ archives 'add index 'typeid2' ('typeid2 ');
When the data volume is about 1 w-10w, after such optimization, if the content page does not have the mark of the relevant article, the generation speed will be three to five times faster.
If there is a related article mark, it will be two to three times faster