SQL record caching

<< Click to Display Table of Contents >>

Navigation:  Application development > Database driver characteristics > SQL drivers >

SQL record caching

 Previous pageReturn to chapter overviewNext page

Two caching mechanisms are used:

Caching Style

Purpose

Live Caching

Done for a cursor, if possible.

Dead Caching

Used if live caching cannot be done.

 

hmtoggle_plus1SQL driver topics

Informix driver

DB2 driver

Sybase CT-Lib driver

PassthroughSQL

SQL transaction control

SQL connection

SQL record modification requirements

SQL record modification behavior

SQL record-locking behavior

SQL table-locking behavior

SQL asynchronous queries

SQL performance tips