So Outside Technology Security CMS
AnQiCMS
Online Demonstration

AnQiCMS (AnQiCMS) version 3.3.12

Calendar 👁️ 284

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.

Related articles

AnQiCMS (AnQiCMS) version 3.3.10

AnQiCMS v3.3.9 with enhanced multilingual support and document customization features, while also optimizing user group settings and template editing, further improving the system's usability and flexibility, and resolving several key issues to provide a more stable user experience.

2024-08-17

AnQiCMS (AnQiCMS) v3.3.8 Edition

AnQiCMS v3.3.8 has further improved the user experience and system stability through optimization of existing features and problem fixes, helping users to be more efficient in content creation and management.

2024-06-28

AnQiCMS (AnQiCMS) version 3.3.6

AnQiCMS v3.3.6 By introducing advanced AI technology and optimizing and fixing existing functions, it further improves the functionality and user experience of the system, ensuring convenience and efficiency in the user's process of using it.

2024-06-02

AnQiCMS (AnQiCMS) version 3.3.5

AnQiCMS v3.3.5 adds new website migration and image watermark features, further enhancing the user experience, optimizing and fixing existing functions, ensuring the system runs more stably and smoothly.

2024-05-01

AnQiCMS (AnQiCMS) version 3.4.1

AnQiCMS v3.4.0 significantly enhanced multilingual support, payment methods, and security features, while optimizing the content management experience, improving system performance and security, ensuring stability and efficiency under multi-site and high-load conditions.

2024-11-09

AnQiCMS v3.4.8 New version released, multi-language feature debuts

User attention!AnQiCMS New version is here, multi-language functionality achieves a leapfrogging upgrade.The multi-language feature performs well, full-page HTML translation is more convenient, the new version adds full-page HTML translation, no matter how complex the page is, images, links, and everything else can be translated into the desired language with one click.We are fortunate that corporate website operators can now easily generate multilingual pages with a few steps, and the format is still intact, whereas in the past, it took a lot of time and effort to translate and format dozens of pages.

2025-03-24

AnQiCMS v3.5.0

New feature - Email automatic sending from child site to main site - Implement system hook (Hook) extension mechanism - Integrate Akismet anti-spam service - Add user URL token identification feature - Navigation supports thumbnails and 4-level hierarchy - Content field `ContentTitles` supports flat mode (`list`) and child mode (`children`) - Custom field extension supports text list, document, category field types, text list, image group supports sorting - Rewrite anchor text replacement logic, supports replacement and bold selection during rendering - Enhanced document list label feature: - `archiveList` supports `showContent` and `showExtra` boolean parameters - Supports using custom field parameters to filter documents in `archiveList`### ⚙️ Feature Optimization - **Template Processing** - Document/category content supports template macro function parsing - Supports `[data-ignore="true"]` ignore tag when replacing template links on mobile - Supports dynamic change of image storage path - Only title and link are considered as duplicates when importing friendly links - Traffic statistics only contains HTTP 200 status code requests - Enhanced `stampToDate` function, supports format= `diff` and `friendly` options - Rewrite SEO processing rules, more flexible configuration, supports custom rules for individual models### 🐛 Bug Fixes - Fixed user personal link generation error - Fixed concurrent Map writing conflict problem - Fixed the problem of not automatically reloading after uploading templates - Fixed memory leak caused by not closing the request body - Fixed PJAX pagination compatibility issues - Fixed remote image download exceptions - Fixed system custom content field configuration error### 🔧 Other Improvements - Added `cwebp` executable permission check - Optimized default value logic for custom fields - Updated HTML cache processing logic - Template `set` directive supports global configuration `{% set name=value global=true %}` - Added `jump` template filter, jump to specified link `{% jump url 302 %}`

2025-07-06

AnQiCMS v3.5.2 Update Record

v3.5.2 AnQiCMS 2025-12-07 This update includes multiple core feature enhancements, performance optimizations, security enhancements, and bug fixes, aiming to improve the functionality, stability, and user experience of the system.Here is the detailed update content.🔐 User authentication and security added Google OAuth third-party authorization login method.Added email verification process for user account registration.Added the password reset feature via email.

2025-12-07