On Fri, Aug 06, 2004 at 01:31:12PM +0200, Brian Ghidinelli wrote:
> Does anyone have any experience using a start/end date pair to
> indicate active/expired records where a NULL end date indicates an
> active record?
NULL end date really means "end date is unknown." An expired record
would be one with an end date in the past.
> I'm looking for performance comparisons to using a simple boolean
> field to indicate the same.
Premature optimization is a Bad Thing(TM). Don't do it!
Micro-optimization on this level is just silly.
Cheers,
D
--
David Fetter david(at)fetter(dot)org http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote!