MySQL Forums
Forum List  »  MyISAM

compression
Posted by: scipio
Date: April 24, 2006 10:58AM

Hello

I am using MyISAM on a table that look somewhat like this

cl_id , cl_feature , cl_some_other_feature , ... , cl_data

were the features are integers or datatimes and the data is text fields about 5-25k most of it is blanks.
(foot print after compression with winrar is about 5-10%)

I would like to have the data compressed.

one possible way to do it is change the data so that it will be binary COMPRESS()ed data but i want the compression to be transparent if possible does MySQL has a feature to compress a single column in transparent way?

Options: ReplyQuote


Subject
Views
Written By
Posted
compression
5676
April 24, 2006 10:58AM
2088
April 24, 2006 11:43AM
2050
April 24, 2006 04:51PM
1852
July 08, 2006 01:00AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.