[jira] [Commented] (DERBY-6135) Request data compression scheme (i.e., gzip of data pages)

["Brett Wooldridge (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/DERBY-6135?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14156171#comment-14156171 ] 

Brett Wooldridge commented on DERBY-6135:
-----------------------------------------

I am also interested in this feature.  I am willing to put some working into an implementation.  I was envisioning something like an additional keyword.  Obviously, it would be non-standard (as there is no standard), something like:
{panel}
CREATE TABLE <tablename> COMPRESSED (
   ...
)
{panel}
I also imaging the best place to do this would be at the "page manager" level, but as this would be new territory for me, tips, warnings, and caveats would be welcome.


> Request data compression scheme (i.e., gzip of data pages)
> ----------------------------------------------------------
>
>                 Key: DERBY-6135
>                 URL: https://issues.apache.org/jira/browse/DERBY-6135
>             Project: Derby
>          Issue Type: Improvement
>          Components: Store
>            Reporter: Tony Brusseau
>
> This is a request for a data compression scheme facility added to Derby (something like gzip of data pages). MySQL and some other databases provide such a feature, see:
> http://dev.mysql.com/doc/innodb-plugin/1.0/en/innodb-compression-internals.html
> The desire for this is because my current database size is 27GB but gzipped, it goes down to 7GB. I wish to scale my database dramatically, but the current disk footprint would prevent me from being able to use Derby.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)