# [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 lines of making
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
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
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
# [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
name
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
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
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