LY_ million data optimization Pure static cache data separation, million data optimization, article content data separation, automatic pure static cache, reduce website resource consumption, improve website access response speed.
For the dynamic optimization test of millions of data, the original table data optimization and static cache speed up, reduce the website resource consumption, improve the website access response speed, simple and easy automatic pure static cache.
Publishing and editing articles will automatically update the static files. Deleting articles and articles in the public status will delete the static files. The current cached page will automatically update the cache of the current page when it exceeds the set cache time limit. At the same time, the static page will also count the number of articles viewed, and will quickly reset to start a new cache.
Plug in features: three functions can be used together or separately:
1. Database optimization is the foundation of speed up optimization.
2. Data separation, article content separation txt optimization, or article description content Meta sub table saved to the 'zbp_ly_cache_post' data table, which is divided into one table per 100000 according to the ID field, to optimize the data table volume and improve the database processing capacity.
3. Static cache 0 calls the database.
The function of caching c_html_js_add.php is to reduce users' access to the repeatedly loaded JS plug-in function. If there is no JS function related to user interaction status, it is recommended to enable this enhanced cache.
The actual measurement is for the dynamic optimization test of 300 million data. Other optimization instructions: Do not use the article archiving module and calendar module in the module management sidebar. Do not use the random display article function of the theme and plug-in. It is recommended not to use the function of the previous article and the next article on the article page.
The response speed of a website cannot be solved by only one plug-in. It is very important to check the slow response caused by the unreasonable design of the theme and other plug-ins, which requires targeted optimization.
Description of open spider UA: spider (five domestic spiders UA, Baidu, Toutiao, 360, Sogou, Shenma) | bingbot | BingPreview (related to Bing) | Applebot (Apple) | Googlebot | Mediapartners Google | Adsbot Google | Google Other (related to Google). You can customize and open foreign or other spiders.
Website 400000 data demonstration: https://hpy.58xp.com/
Real pure static rules. You can turn off PHP and MySQL to access static pages. Currently, only nginx rules are supported.
Look at the speed measurement effect of enabling pure static cache: the browser access time is 46 milliseconds.
Let's take a look at the speed measurement effect of turning off the pure static cache: the browser access time is 109 milliseconds, and the response speed is more than 2 times slower when the pure static cache is not turned on.
The user login status of the static cache page is lost, and the theme customization adaptation c_html_js_add.php dynamically calls the login status page for processing
https://zb.lyphp.com/ly-notepad/119.html
Update log:
Update 20250610: Optimize some compatibility issues.
Update 20250320: Fixed the problem that there were no articles on the tabs in the previous version. If there was this problem, reset and clear the tag synchronization data first, then resynchronize the TAG data, and then reset the static state.
Update 20250222: Optimize the statistics mode of cache article list and optimize some details.
Update 20250115: Optimize and reset some static compatibility problems, and increase the cache aging of the whole station by minutes.
Update 20241219: update and optimize the data processing and some details of the sub table.
20241007 update: add non static setting path, add independent setting of paging aging, and add pure static aging update.
Update 20240630: The article table splitting function is divided into one table for every 100000 ID fields.
Update 20240327: update a security issue, please update the latest version.
Update 20230902: optimize some details and add independent static settings for multiple domain names.
Update 20230709: add sub table and separate article content replacement settings.
