Version: AnQICMS v3.3.12
Release date: 2024-09-05
Improvement direction: Document query performance optimization

Update Overview

This update is mainly optimized for querying a large number of documents to improve document query efficiency, reduce server resource consumption, and improve the overall performance of the website. After testing, when the total number of documents reaches 100 million, the loading speed of the document details and document list is within 1 second.

Important Tips: When the number of website documents exceeds 100,000, it is recommended to set up the background content:

  • Turn off multi-category support
  • Disable document sorting function
  • Turn off full text search function In template tags, avoid usingLIKEQuery to avoid affecting performance.

Main optimization

  • Adjustment of data statistics: Use file storage instead of data statistics details, abandon database storage, reduce database burden, and improve statistical performance.

  • Document index adjustment: Optimized document index, improved document query method, limiting the maximum page turn of the document list to 1,000 pages, preventing performance problems caused by excessive page turn.

  • Statistical query optimization: When conducting queries with a statistical number of more than 100,000, no longer usedCOUNTPerform accurate statistics and optimize query efficiency.

  • Database support tuning: Improve database table structure, remove support for MyISAM, currently only InnoDB is supported to provide better performance and data security.

  • File Cache Management: In file cache mode, the cached files are automatically cleaned when the system starts to ensure the efficiency of cache management.