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

David Strauss david at fourkitchens.com
Sat May 3 14:18:48 UTC 2008


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

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

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



More information about the development mailing list