From: Eric Bergen
Date: December 4 2004 4:45am
Subject: Re: COMPRESS() vs myisampack
List-Archive: http://lists.mysql.com/mysql/176861
Message-Id: <11b1bd99041203204558dda882@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

myisampack will result in a smaller table. The only downside is that
the table becomes read only.


On Fri, 03 Dec 2004 09:31:22 +0100, Jacob Friis <lists@stripped> wrote:
> I have a table with lots of text data, and would like to compress this
> in order to save space.
> 
> I would either compress the whole table with myisampack or just the text
> data with COMPRESS().
> 
> When I SELECT from this table, would it be equally fast to use
> UNCOMPRESS() for text data or use a table packed by myisampack?
> 
> Thanks,
> Jacob
> 
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=eric.bergen@stripped
> 
> 


-- 
Eric Bergen
eric.bergen@stripped
bleated.com