dedecms template Dedecms V31 Optimization method for generating HTML speed

Due to various reasons such as version compatibility, the index of dedecms is actually a bit confusing. If the index is set appropriately, the speed of dedecms HTML generation will be affected mainly when obtaining a list of articles that are not sorted by default. Due to the need to reorder the data, When the volume is large, the speed will be very unsatisfactory. You can easily optimize it through the following steps:
1. Enter phpmyadmin and delete the indexes of dedecms site dede_archives except the index of ID primary key;
2. Use SQL to create the following index:
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`);
In the range of data volume of about 1W-10W, after such optimization, if the content page does not have relevant article tags, the generation speed will be three to five times faster
If there are related article tags, it will also be two to three times faster

The above introduces the optimization method of dedecms template Dedecms V31 to generate HTML speed, including the content of dedecms template. I hope it will be helpful to friends who are interested in PHP tutorials.