Data query method, cache server and terminal

Abstract

The embodiment of the invention provides a data query method, a cache server and a terminal. The data query method comprises the following steps: receiving and analyzing an SQL statement with a cacheidentifier sent by the terminal, wherein the SQL statement further comprises a query table name, a query table version number, a query parameter and a user-defined operation name; matching a first keyvalue composed of the query table name, the query table version number, the query parameter and the user-defined operation name with a second key value to obtain a matching result; and returning thequery result data to the terminal according to the matching result. The cache server is used for executing the method. According to the data query method, the SQL statement with the cache identifier sent by the terminal is received; matching is performed on the first key value and the second key value, corresponding to the SQL statement; according to the matching result, the query result data is obtained, so that the query result data can be obtained without performing query through the database each time or performing complex analysis operation on SQL statements, so that the data query efficiency is improved, and the load of the database is reduced.

Description

technical field [0001] The embodiment of the present invention relates to the field of computer technology, and in particular to a data query method, a cache server and a terminal. Background technique [0002] Many web applications store data in a relational database management system (RDBMS for short), from which the application server reads the data and displays it in the browser. However, with the increase of data volume and the concentration of access, the burden of REBMS will increase, the response of the database will deteriorate, and the website display delay will be significantly affected. [0003] figure 1 A schematic diagram of a data reading process provided for the prior art, such as figure 1 As shown, since the cache system has a high-performance distributed storage object cache system (Memcached) and data synchronization between the database, it is an indirect cache. Therefore, during the data reading process, the cached data cannot be read through the SQL s...

AI Technical Summary

Problems solved by technology

A problem brought about by this is that even if there is no change in the data, the database needs to perform complex operations such as syntax analysis, semantic analysis, permission check, expression conversion, variable binding, and execution plan generation. large, the database load gets higher and higher, and eventually performance plummets

The worst thing is to encounter SQL statements that are not written according to the coding standards, and variable binding is not used, which makes the database perform repeated hard parsing, resulting in a large number of Latch locks in the database

That will undoubtedly greatly increase the load on the database, thereby reducing the overall performance of the system

Images