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

Earnie Boyd earnie at users.sourceforge.net
Sat May 3 23:07:27 UTC 2008

> -----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/

More information about the development mailing list