<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
i agree here. the storage would be trivial, considering how much other
data we store anyway. even if you have 500k users, that would add what?
an additional 8 char(0) fields would be something like .5M, but the db
would still be so large that that's a small percentage.<br>
<br>
David Strauss wrote:
<blockquote
cite="mid:1632286267-1209824357-cardhu_decombobulator_blackberry.rim.net-1763706451-@bxe038.bisx.prod.on.blackberry"
type="cite">
<pre wrap="">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 <a class="moz-txt-link-rfc2396E" href="mailto:earnie@users.sourceforge.net"><earnie@users.sourceforge.net></a>
Date: Sat, 03 May 2008 09:59:43
<a class="moz-txt-link-abbreviated" href="mailto:To:development@drupal.org">To:development@drupal.org</a>
Subject: Re: [development] User Status [WAS: User last access]
Quoting Larry Garfield <a class="moz-txt-link-rfc2396E" href="mailto:larry@garfieldtech.com"><larry@garfieldtech.com></a>:
</pre>
<blockquote type="cite">
<pre wrap="">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).
</pre>
</blockquote>
<pre wrap=""><!---->
I like option B for this.
Earnie -- <a class="moz-txt-link-freetext" href="http://for-my-kids.com/">http://for-my-kids.com/</a>
-- <a class="moz-txt-link-freetext" href="http://give-me-an-offer.com/">http://give-me-an-offer.com/</a>
</pre>
</blockquote>
<br>
</body>
</html>