Version: AnQiCMS v3.3.12
Release Date: 2024-09-05
Improvement Direction: Document Query Performance Optimization

Update Overview

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

Important reminder: 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 feature
  • Disable full-text search feature Avoid using in template tagsLIKEQuery to avoid affecting performance

Main optimization

  • Adjust the data statistics methodThe data statistics details are now stored in files, instead of databases, to reduce the burden on the database and improve the performance of statistics.

  • Adjust the document indexOptimized 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.

  • Statistical query optimizationWhen performing queries with a count exceeding 100,000, it will no longer be usedCOUNTPerform accurate statistics to optimize query efficiency.

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

  • File cache managementIn file cache mode, the system automatically cleans up cache files at startup to ensure efficient cache management.