BooleanField

[Ruslan Zasukhin]

On 6/4/09 4:20 PM, "Thomas Flemming" <tf at ttqv.com> wrote:

Hi Thomas,
 
> how much diskspace does a Field of type boolean requiere?

Wiki

1 bit per record
 
> I have to add 20 boolean-values to a table and asking myself, if it would be
> better to bit-mask them together and store in one interger-field instead of
> having 20 boolean-fields.

NOT with Valentina   :)
 
Actually other dbms self sometimes pack bits internally.
So you should not care about this.

-------- 
> Im also wondering whats faster:
> - reading one integer and extracitng 20 booleans out of the bits
> or
> - reading 20 booleans.

One integer will be faster I think.


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]