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, mainly because the index is not sorted by default. ArticleThe speed of large data volumes is not ideal due to the need to re-sort the list. 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 '# @__ archives 'add index'click' ('click ');
Alter table '# @__ archives 'add index 'typeid' ('typeid ');
Alter table '# @__ archives 'add Index' arcrank' ('arcrank ');
Alter table '# @__ archives 'add Index' sortrank' ('sortrank ');
Alter table '# @__ archives 'add index 'senddate' ('senddate ');
Alter table '# @__ archives 'add index 'pubdate' ('pubdate ');
Alter table '#@__ archives 'add index 'litpic' ('litpic ');
Alter table '# @__ 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