On May 30, 2006, at 5:48 AM, Eci Souji wrote:
Hmmm that works too. So I guess my next question is which is a
better designed system; one large table with bools and views or six
small tables with stored procs to move data between tables?
That depends entirely on your access patterns and how
Roman Neuhauser wrote:
# [EMAIL PROTECTED] / 2006-05-29 08:10:43 -0400:
Roman Neuhauser wrote:
# [EMAIL PROTECTED] / 2006-05-28 16:13:20 -0400:
Basically we've got several different "states" that an item can be in.
From what I've seen the way many places seem to deal with them is
som
# [EMAIL PROTECTED] / 2006-05-29 08:10:43 -0400:
> Roman Neuhauser wrote:
> ># [EMAIL PROTECTED] / 2006-05-28 16:13:20 -0400:
> >
> >>Basically we've got several different "states" that an item can be in.
> >>From what I've seen the way many places seem to deal with them is
> >>something along the
Chris wrote:
Eci Souji wrote:
Hi, I was wondering if anyone had any experience with this type of
setup and could share what they've learned.
Basically we've got several different "states" that an item can be in.
From what I've seen the way many places seem to deal with them is
something along
Roman Neuhauser wrote:
# [EMAIL PROTECTED] / 2006-05-28 16:13:20 -0400:
Basically we've got several different "states" that an item can be in.
From what I've seen the way many places seem to deal with them is
something along the lines of making bool values that act as
switches...
Ex:
table ite
# [EMAIL PROTECTED] / 2006-05-28 16:13:20 -0400:
> Basically we've got several different "states" that an item can be in.
> From what I've seen the way many places seem to deal with them is
> something along the lines of making bool values that act as
> switches...
>
> Ex:
> table items:
> item_id
Eci Souji wrote:
Hi, I was wondering if anyone had any experience with this type of
setup and could share what they've learned.
Basically we've got several different "states" that an item can be in.
From what I've seen the way many places seem to deal with them is
something along the lines of m
Hi, I was wondering if anyone had any experience with this type of
setup and could share what they've learned.
Basically we've got several different "states" that an item can be in.
From what I've seen the way many places seem to deal with them is
something along the lines of making bool values t
