Uploaded image for project: 'Oozie'
  1. Oozie
  2. OOZIE-1462

Compress lob columns before storing in database

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 4.1.0
    • Component/s: None
    • Labels:
      None

      Description

      Storing huge data in lobs is very inefficient. Making Oozie compress the data before storing will reduce size of data to be stored in lobs and help in reducing the time for queries. Also most databases like oracle, mysql support storing lob data in tablerow (inline) if the data is of smaller size. Inline storage has much better performance compared to outline storage (storage outside of tablerow)

        Attachments

        1. OOZIE-1462.patch
          168 kB
          Virag Kothari

          Issue Links

            Activity

              People

              • Assignee:
                virag Virag Kothari
                Reporter:
                virag Virag Kothari
              • Votes:
                0 Vote for this issue
                Watchers:
                6 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: