You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@oozie.apache.org by "Virag Kothari (JIRA)" <ji...@apache.org> on 2013/07/23 01:14:48 UTC

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

Virag Kothari created OOZIE-1462:
------------------------------------

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


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