Derby
  1. Derby
  2. DERBY-3907

Save useful length information for Clobs in store

    Details

    • Type: Improvement Improvement
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 10.5.1.1
    • Fix Version/s: 10.5.1.1
    • Component/s: JDBC, Store
    • Labels:
      None
    • Bug behavior facts:
      Performance

      Description

      The store should save useful length information for Clobs. This allows the length to be found without decoding the whole data stream.
      The following thread raised the issue on what information to store, and also contains some background information: http://www.nabble.com/Storing-length-information-for-CLOB-on-disk-tp19197535p19197535.html

      The information to store, and the exact format of it, is still to be discussed/determined.
      Currently two bytes are set aside for length information, which is inadequate.

      1. derby-3907-7a-write_new_header_format-PREVIEW.diff
        44 kB
        Kristian Waagan
      2. derby-3907-7a-write_new_header_format.stat
        0.8 kB
        Kristian Waagan
      3. derby-3907-7a-write_new_header_format.diff
        76 kB
        Kristian Waagan
      4. derby-3907-7a-write_new_header_format.diff
        76 kB
        Kristian Waagan
      5. derby-3907-7a3-use_new_header_format.stat
        0.3 kB
        Kristian Waagan
      6. derby-3907-7a3-use_new_header_format.diff
        27 kB
        Kristian Waagan
      7. derby-3907-7a2-use_new_framework.stat
        0.5 kB
        Kristian Waagan
      8. derby-3907-7a2-use_new_framework.diff
        29 kB
        Kristian Waagan
      9. derby-3907-7a1-write_new_header_format.diff
        20 kB
        Kristian Waagan
      10. derby-3907-6a-SQLClob_stream_descriptor_sync.diff
        1 kB
        Kristian Waagan
      11. derby-3907-5a-use_getStreamWithDescriptor.stat
        0.8 kB
        Kristian Waagan
      12. derby-3907-5a-use_getStreamWithDescriptor.diff
        30 kB
        Kristian Waagan
      13. derby-3907-4a-add_getStreamWithDescriptor.stat
        0.3 kB
        Kristian Waagan
      14. derby-3907-4a-add_getStreamWithDescriptor.diff
        13 kB
        Kristian Waagan
      15. derby-3907-3b-readertoutf8stream_cleanup.diff
        15 kB
        Kristian Waagan
      16. derby-3907-3a-readertoutf8stream_cleanup.stat
        0.3 kB
        Kristian Waagan
      17. derby-3907-3a-readertoutf8stream_cleanup.diff
        18 kB
        Kristian Waagan
      18. derby-3907-3a-readertoutf8stream_cleanup.diff
        18 kB
        Kristian Waagan
      19. derby-3907-2c-header_write_preparation-PREVIEW.stat
        0.7 kB
        Kristian Waagan
      20. derby-3907-2c-header_write_preparation-PREVIEW.diff
        38 kB
        Kristian Waagan
      21. derby-3907-2c-header_write_preparation.stat
        0.7 kB
        Kristian Waagan
      22. derby-3907-2c-header_write_preparation.diff
        48 kB
        Kristian Waagan
      23. derby-3907-2c-header_write_preparation.diff
        48 kB
        Kristian Waagan
      24. derby-3907-2b-header_write_preparation.stat
        0.5 kB
        Kristian Waagan
      25. derby-3907-2b-header_write_preparation.diff
        15 kB
        Kristian Waagan
      26. derby-3907-2b-header_write_preparation.diff
        14 kB
        Kristian Waagan
      27. derby-3907-1a-alternative_approach.diff
        12 kB
        Kristian Waagan

        Issue Links

          Activity

          No work has yet been logged on this issue.

            People

            • Assignee:
              Kristian Waagan
              Reporter:
              Kristian Waagan
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development