List:General Discussion« Previous MessageNext Message »
From:Eric Bergen Date:December 4 2004 4:45am
Subject:Re: COMPRESS() vs myisampack
View as plain text  
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=1
> 
> 


-- 
Eric Bergen
eric.bergen@stripped
bleated.com
Thread
COMPRESS() vs myisampackJacob Friis3 Dec
  • Re: COMPRESS() vs myisampackEric Bergen4 Dec