Cache-based quick query method and device, computer equipment and storage medium

Abstract

The invention discloses a cache-based quick query method. The method comprises the steps of obtaining a query demand of a user for querying required information; detecting whether required data existsin cache data or not on the basis of the query demand; if the required data exists, acquiring the required data, and ending the query; if the required data does not exist, switching to a database toinquire required information, and calling after the required information is inquired; and taking the called required information data as value, taking the id of a class name plus the required data askey, and storing the value and the key in cache data. The consistency of data in a database and data in a cache is guaranteed through distributed cache middleware in a cluster environment, high availability and persistence of the cache middleware are guaranteed, the problem that the disk response speed is low due to the fact that the data size is too large is solved, and data needed by a query command are rapidly and accurately obtained; the cache of the memory space is periodically cleared, and the situation of overflow due to overlarge data volume is prevented.

Description

technical field [0001] The invention relates to the technical field of the Internet, in particular to a cache-based fast query method, device, computer equipment and storage medium. Background technique [0002] At this stage, as the number of users and business volume in the system continues to grow, the business continues to accumulate and the amount of data also continues to grow. At this time, the server response is getting slower and slower, and the disk throughput encounters a bottleneck. Optimizing SQL can no longer solve the problem. It is necessary to solve the corresponding performance problems by adding data to the cache. [0003] For the above performance problems, third-party caching middleware is required. Although the JVM itself has a cache, it is not suitable for use in a cluster environment because it is a stand-alone machine and cannot be recovered. In a cluster environment, you need to use distributed cache middleware; when using cache, you need to ensure...

AI Technical Summary

Problems solved by technology

[0005] The embodiment of the present invention provides a cache-based fast query method, device, computer equipment, and storage medium, aiming to solve the existing problem of slow disk response to query requirements due to excessive data volume

Images