[thelist] database structure for speedier queries

[Martin Burns]

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/