SQL Performance enhancement by local client cache
Publication Date: 2016-Feb-29
The IP.com Prior Art Database
This invention focuses on the performance enhancement for SQLs which are complex, time consuming and would be executed multiples time. In this invention, a new method called: ‘SQL local cache’ is introduced to improve performance of SQL. For an SQL that is time consuming and executed frequently or multiples times, its statement text and corresponding result set will be saved within local cache of client. Before next SQL statement (come from application) sent to database server, it will be tried to match with existed SQL text saved in cache. If an exactly matched SQL could be found in cache, corresponding result set will be returned instead of fetching data from database system server.