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-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

              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: