Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2017
    Location
    Palo Alto, Ca.
    Posts
    6

    Unanswered: SQL Caching for DB2

    Hello,

    Is anyone implementing SQL caching? We have created a solution that caches SQL in the application server to avoid network latency to the database. I would love to get your experience on how you all are caching SQL.

    Thanks.

    Munchai

  2. #2
    Join Date
    Jul 2016
    Location
    Moscow
    Posts
    282
    Provided Answers: 41
    Hello Munchai,

    This functionality is implemented in the DB2 JDBC driver.
    IBM Data Server Driver for JDBC and SQLJ statement caching.
    Regards,
    Mark.

  3. #3
    Join Date
    Aug 2017
    Posts
    1

    Resultset caching vs. Prepared statement caching

    Quote Originally Posted by mark.bb View Post
    Hello Munchai,

    This functionality is implemented in the DB2 JDBC driver.
    IBM Data Server Driver for JDBC and SQLJ statement caching.
    Mark,

    The DB2 driver is a prepared statement cache, which optimizes the queries that are executed on the DB side by avoiding prepared query parsing. I think Munchai may be talking about resultset caching, which is something that Heimdall Data provides as a JDBC shim. The way that Heimdall works is that it looks for repetition in the queries before they even are sent to the DB2 JDBC driver, and caches and returns resultsets. This avoids the round trip to the database completely. Both provide a benefit, but do so in different ways, and will help with different queries. This logic implements invalidation on writes to simplify configuration, but is also tuneable using rules that can be configured at runtime to enable or disable caching under various conditions.

    Erik Brandsberg
    CTO, Heimdall Data

    edit: wording and added context.
    Last edited by ebrandsberg; 08-25-17 at 12:35.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •