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
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
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
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
# [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
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
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
# [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