db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mike Matrigali (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DERBY-6135) Request data compression scheme (i.e., gzip of data pages)
Date Tue, 16 Apr 2013 18:33:16 GMT

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

Mike Matrigali commented on DERBY-6135:

good feedback, I had always assumed apps looking for compression would be string/blob centric.

For your app do your long id's tend to start at 0 and grow?  Derby internally implements a
compression technique for number data
that is highly optimized for numbers that are small but types that support much bigger.  We
only use this for metadata right now.

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

View raw message