[thelist] database structure for speedier queries

[Nan Harbison]

You guys are brilliant!
Thanks,
Nan 

-----Original Message-----
From: thelist-bounces at lists.evolt.org
[mailto:thelist-bounces at lists.evolt.org] On Behalf Of Martin Burns
Sent: Sunday, December 02, 2007 10:09 AM
To: thelist at lists.evolt.org
Subject: Re: [thelist] database structure for speedier queries


On 2 Dec 2007, at 13:48, r937 wrote:

> i would not use a boolean to indicate whether the project was complete
>
> instead, i would use a column called completed_date

and that's not only for good DBA reasons; it's because I'll put money on
someone asking, some time down the track "when were they completed?"

So you get two bits of information for the price of one field, one of which
is going to be *really* hard to find out post hoc. Sounds bloody efficient
to me.

Cheers
Martin

--
 > Spammers: Send me email -> yumyum at easyweb.co.uk to train my filter  >
http://dspam.nuclearelephant.com/





-- 

* * Please support the community that supports you.  * *
http://evolt.org/help_support_evolt/

For unsubscribe and other options, including the Tip Harvester and archives
of thelist go to: http://lists.evolt.org Workers of the Web, evolt !