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 using
LIKE
Query 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 used
COUNT
Perform 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.