[jira] [Updated] (OOZIE-1462) Compress lob columns before storing in database

["Virag Kothari (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/OOZIE-1462?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Virag Kothari updated OOZIE-1462:
---------------------------------

    Attachment: OOZIE-1462.patch

https://reviews.apache.org/r/14026/
                
> Compress lob columns before storing in database
> -----------------------------------------------
>
>                 Key: OOZIE-1462
>                 URL: https://issues.apache.org/jira/browse/OOZIE-1462
>             Project: Oozie
>          Issue Type: Improvement
>            Reporter: Virag Kothari
>            Assignee: Virag Kothari
>         Attachments: OOZIE-1462.patch
>
>
> 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)

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira