Get the App
SLTechnology News&Howtos  ›  Internet Technology  › 

Access is slower after using MC

Shulou Source: shulou.com Published: 2022-06-03 07:02:55 09月23日 Update

[phenomenon]: the access speed is slower after using MC than without.

[cause Analysis]: the list page is designed to load 4 more collocation messages for drop-down refresh, and a maximum of 100 collocation information will be displayed on a single page, and then paged. Before modification, all the data of a single page is taken out and stored in MC, resulting in a long response time.

[solution]:

Drop down the page that loads 4 entries, and change it to query only the first four records and store them in MC at the beginning, and then query the database and store them in MC when the other records are loaded. When the cache has not expired, get the results directly from MC.

Tags: Data drop-down query information reason cause analysis database scheme time phenomenon result cache solution speed page Chenggang analysis design Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno Huawei Shulou Tech Info Shulou Information MySQL Xiaomi