Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-3907

Save useful length information for Clobs in store

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: 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.

        Attachments

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

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: