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