[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.
Cheers
Martin
--
> Spammers: Send me email -> yumyum at easyweb.co.uk to train my filter
> http://dspam.nuclearelephant.com/
More information about the thelist
mailing list