Version: AnQICMS v3.3.12
Release Date: 2024-09-05
Improvement Direction: Optimizing document query performance

Update Overview

This update mainly optimizes the query of a large number of documents to improve document query efficiency, reduce server resource consumption, and enhance the overall performance of the website.The document details and document list load within 1 second when the total number of documents reaches 100 million.

Important Notice:When the number of website documents exceeds 100,000, it is recommended to set in the background content settings:

  • Disable Multi-class Support
  • Disable Document Sorting Function
  • Disable Full-text Search Function Avoid using in template tagsLIKEQuery to avoid affecting performance.

Main Optimization

  • Data statistics method adjustmentThe data statistics details are now stored in files instead of databases to reduce database load and improve statistics performance.

  • Document index adjustmentOptimized document indexing, improved document query methods, limited the maximum number of pages in the document list to 1000, to prevent performance issues caused by too many page turns.

  • Query optimization statistics【en】When performing queries with a count exceeding 100,000, no longer useCOUNTPerform accurate statistics to optimize query efficiency.

  • Database supports adjustment【en】Improve the database table structure, remove support for MyISAM, currently only supporting InnoDB to provide better performance and data security.

  • 【en】File cache managementIn the file cache mode, the system automatically clears cache files upon startup to ensure the efficiency of cache management.