Due to version compatibility and other reasons, in fact, DEDECMS index is a bit confusing, if the index is set to fit, affect the dedecmshtml generation speed, mainly to get the list of articles not by default sorted by the time, due to reorder, the data volume is very high speed is not ideal, You can easily optimize by following these steps:
1, enter the phpMyAdmin, the DEDECMS site dede_archives except the ID primary key index of the index delete;
2. Create the following index with SQL:
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 around 1w-10w, after such optimization, if the content page does not have the relevant article tag, the generation speed will be three to five times times faster.
Two to three times times faster if there are related article markers
http://www.bkjia.com/PHPjc/318137.html www.bkjia.com true http://www.bkjia.com/PHPjc/318137.html techarticle due to version compatibility and other reasons, in fact, DEDECMS index is a bit confusing, if the index is set to fit, the impact of dedecmshtml generation speed, the main is to get no press by default ...
