[Nottingham] SQLite and 'locking'

[Michael Erskine]

On Tuesday 27 February 2007 12:35, Martin wrote:
> > How do you indicate a dirty baby seat?
> Use a bit field instead of enumerating, or even add more enumerations...?
> > In general i strongly dislike "status" fields and prefer separating
> > things into different fields in all but the most trivial of cases.
> Which is the more expensive: One column of enumerations or multiple
> columns of flags/counts?

You wouldn't have any status field(s): you would have a "seat_problems" 
or "seat_info" table that would list all problems with all seats and that has 
a foreign key pointing back to the id of the seat.

Regards,
Michael Erskine.

-- 
Riffle West Virginia is so small that the Boy Scout had to double as the
town drunk.



		
___________________________________________________________ 
All New Yahoo! Mail – Tired of Vi at gr@! come-ons? Let our SpamGuard protect you. http://uk.docs.yahoo.com/nowyoucan.html