Zen-cart plug-in ceon_uri_mapping_seo Performance Optimization

After the plug-in is enabled, when you enter a connection in the webpage, the system will query whether there are URL link rules that meet the conditions. This will affect the loading speed of the webpage, but if there are relatively few items, the fewer URL rules, the less impact on performance. However, if there are more products, the more URLs, the slower the query speed. This is why the loading speed of mmocode and wowcart is quite different.

Solution: Enable MySQL cache.

Solution: run the following command on the database:
Set global query_cache_size = 102400000;

SetHtml_output.phpFile Content

Select URI from...Change

Select SQL _cache URI from... 

Test results: for the same page, the speed of the first visitor is not much different from that of the previous one, and the access speed of the second visitor is significantly improved.