Re: COMPRESS() vs myisampack

2004-12-03 Thread Eric Bergen
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 <[EMAIL PROTECTED]> wrote: > I have a table with lots of text data, and would like to compress this > in order to save space. > > I would either compr

COMPRESS() vs myisampack

2004-12-03 Thread Jacob Friis
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