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 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/[EMAIL PROTECTED] > > -- Eric Bergen [EMAIL PROTECTED] bleated.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
