Uploaded image for project: 'James Server'
  1. James Server
  2. JAMES-2927

Avoid null value binding in prepared statements

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 3.5.0
    • cassandra
    • None

    Description

      A tumbstone is created when a null value is specified in a prepared statement.

      This is due to the fact that null has the meaning `remove` and not the meaning `unspecified`, which is represented by no binding at all.

      Of course unwanted tumbstones occurs with a performance cost.

      The recommended method for fixing this is to separate nullable parts of the statements in other prepared statements, that can logically grouped together without overhead using batch statements.

      Read this for further information: https://thelastpickle.com/blog/2016/09/15/Null-bindings-on-prepared-statements-and-undesired-tombstone-creation.html

      Attachments

        Activity

          People

            Unassigned Unassigned
            btellier Benoit Tellier
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: