Dismiss
InnovationQ and the IP.com Prior Art Database will be updated on Sunday, December 15, from 11am-2pm ET. You may experience brief service interruptions during that time.
Browse Prior Art Database

SQL Performance enhancement by local client cache

IP.com Disclosure Number: IPCOM000245311D
Publication Date: 2016-Feb-29

Publishing Venue

The IP.com Prior Art Database

Abstract

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.