[thelist] database structure for speedier queries

Martin Burns martin at easyweb.co.uk
Sun Dec 2 09:08:45 CST 2007

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.


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

More information about the thelist mailing list