[development] User Status [WAS: User last access]

[Earnie Boyd]

> -----Original Message-----
> From: Earnie Boyd <earnie at users.sourceforge.net>
>
> Date: Sat, 03 May 2008 09:59:43
> To:development at drupal.org
> Subject: Re: [development] User Status [WAS: User last access]
>
>
> Quoting Larry Garfield <larry at garfieldtech.com>:
>
>>
>> A) Make status have a lot of different states with int/consts.
>> B) Make status a bitmask field (compact but harder to query).
>> C) Break status out into a series of is_foo fields (possibly a lot of
>> needless data).
>>
>
> I like option B for this.
>

Quoting David Strauss <david at fourkitchens.com>:

> Remember that MySQL cannot truly index bitmasks. Consider a series of 
> CHAR(0) columns, which would take the same space but be indexable.
>

I was thinking more of an integer field used as a bitmask.

Earnie -- http://for-my-kids.com/
-- http://give-me-an-offer.com/