Re: Efficient Boolean Storage

On Wednesday 04 Dec 2002 1:06 am, Chris White wrote:
> Hello,
>
> I need to store many (e.g. 30) booleans and am wondering what is the
> most efficient way to store them.  I can think of four options.
>
> Option 1...Use 'bool' data type
> No good since each value will require 1 byte rather than 1 bit.

Depends what you're going to use them for. Are these 30 flags that should be
grouped together? Will the users/app want all together or one at a time? Will
they feature in WHERE clauses?

--
  Richard Huxton