MySQL Forums :: InnoDB :: using enum as means of compression


Advanced Search

using enum as means of compression
Posted by: postaholic066 SQL ()
Date: March 28, 2010 09:40AM

Hi,
I was looking for various ways I could compress data in my MySQL database.
- Creating lookup tables
- using enums
Is there some other solution?

Sticking to enums...
I am doubtful about how does InnoDB execute the following where clause containing an enum column named 'colFoo' in a table named 'foo'?

" SELECT ... FROM foo WHERE colFoo = 'someString' "
Would it scan the table if 'someString' is not in the enum declaration?

Options: ReplyQuote


Subject Views Written By Posted
using enum as means of compression 3173 postaholic066 SQL 03/28/2010 09:40AM
Re: using enum as means of compression 1237 Rick James 03/29/2010 10:47PM
Re: using enum as means of compression 1186 postaholic066 SQL 04/02/2010 02:27AM
Re: using enum as means of compression 1043 Saurabh Deshpande 04/02/2010 06:41AM
Re: using enum as means of compression 1113 postaholic066 SQL 04/03/2010 12:54AM
Re: using enum as means of compression 1114 Rick James 04/02/2010 07:32PM
Re: using enum as means of compression 1192 postaholic066 SQL 04/03/2010 01:10AM
Re: using enum as means of compression 1958 Rick James 04/03/2010 09:40AM


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.