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

Save useful length information for Clobs in store

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 10.5.1.1
    • 10.5.1.1
    • JDBC, Store
    • None
    • 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
          14 kB
          Kristian Waagan
        3. derby-3907-2b-header_write_preparation.diff
          15 kB
          Kristian Waagan
        4. derby-3907-2b-header_write_preparation.stat
          0.5 kB
          Kristian Waagan
        5. derby-3907-2c-header_write_preparation.diff
          48 kB
          Kristian Waagan
        6. derby-3907-2c-header_write_preparation.diff
          48 kB
          Kristian Waagan
        7. derby-3907-2c-header_write_preparation.stat
          0.7 kB
          Kristian Waagan
        8. derby-3907-2c-header_write_preparation-PREVIEW.diff
          38 kB
          Kristian Waagan
        9. derby-3907-2c-header_write_preparation-PREVIEW.stat
          0.7 kB
          Kristian Waagan
        10. derby-3907-3a-readertoutf8stream_cleanup.diff
          18 kB
          Kristian Waagan
        11. derby-3907-3a-readertoutf8stream_cleanup.diff
          18 kB
          Kristian Waagan
        12. derby-3907-3a-readertoutf8stream_cleanup.stat
          0.3 kB
          Kristian Waagan
        13. derby-3907-3b-readertoutf8stream_cleanup.diff
          15 kB
          Kristian Waagan
        14. derby-3907-4a-add_getStreamWithDescriptor.diff
          13 kB
          Kristian Waagan
        15. derby-3907-4a-add_getStreamWithDescriptor.stat
          0.3 kB
          Kristian Waagan
        16. derby-3907-5a-use_getStreamWithDescriptor.diff
          30 kB
          Kristian Waagan
        17. derby-3907-5a-use_getStreamWithDescriptor.stat
          0.8 kB
          Kristian Waagan
        18. derby-3907-6a-SQLClob_stream_descriptor_sync.diff
          1 kB
          Kristian Waagan
        19. derby-3907-7a1-write_new_header_format.diff
          20 kB
          Kristian Waagan
        20. derby-3907-7a2-use_new_framework.diff
          29 kB
          Kristian Waagan
        21. derby-3907-7a2-use_new_framework.stat
          0.5 kB
          Kristian Waagan
        22. derby-3907-7a3-use_new_header_format.diff
          27 kB
          Kristian Waagan
        23. derby-3907-7a3-use_new_header_format.stat
          0.3 kB
          Kristian Waagan
        24. derby-3907-7a-write_new_header_format.diff
          76 kB
          Kristian Waagan
        25. derby-3907-7a-write_new_header_format.diff
          76 kB
          Kristian Waagan
        26. derby-3907-7a-write_new_header_format.stat
          0.8 kB
          Kristian Waagan
        27. derby-3907-7a-write_new_header_format-PREVIEW.diff
          44 kB
          Kristian Waagan

        Issue Links

          relates to

          Improvement - An improvement or enhancement to an existing feature or task. DERBY-4652 Provide mean to save length information when inserting CLOBs using the JDBC 4.0 "length less overrides"

          • Major - Major loss of function.
          • Open

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: