[
https://issues.apache.org/jira/browse/OOZIE-1462?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13715935#comment-13715935
]
Mohammad Kamrul Islam commented on OOZIE-1462:
----------------------------------------------
Adding to Robert's comment:
* Overall it is a good step forward.
* How much performance degradation for compression and decompression(most
frequent one)?
* Will this compression/decompression be active for all the time? Or it could
be configurable using oozie-site.xml.
* What other fields? Or all *lob fields.
* Please consider MySQL case as well.
> 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
