Client-side statement cache

摘要

Embodiments include a method, apparatus and computer program product for providing instructions from a database client to a database server. The method includes the steps of receiving from a database a representation of a first instruction and an associated identifier. The representation of the first instruction and the associated identifier are stored in a cache. A second instruction, from an application, is matched with the representation of the first instruction stored in the cache. The associated identifier is retrieved from the cache based on the matching and the associated identifier is sent to the database server. Upon receipt of the associated identifier, the database server executes the first instruction.

主权项

1. A method of providing instructions from a database client to a database server, comprising:
receiving a plurality of embedded structured query language (SQL) instructions; sending the plurality of embedded SQL instructions to the database server, wherein the database server analyzes the plurality of embedded SQL instructions; receiving, from the database server and based on the analyzing by the database server, a representation of a first instruction and an associated identifier, wherein the first instruction comprises a pre-processed dynamic SQL instruction converted from a first embedded SQL instruction from the plurality of embedded SQL instructions; storing the representation of the first instruction and the associated identifier in a cache; receiving a second instruction from an application, wherein the second instruction is not identical to the first instruction and comprises a second embedded SQL instruction from the plurality of embedded SQL instructions; matching the representation of the first instruction and the second instruction; retrieving the associated identifier from the cache based on the matching; and sending the associated identifier to the database server, wherein, upon receiving the associated identifier the database server executes the first instruction.