Oh, and response time should be 'faster', since you can locate the different
tables on separate storage devices, allowing for concurrent drive access to the
different parts of the item.
Steve Brazill wrote:
> You should split the data-fields into tables containing 'categories' of
> fields.
>
You should split the data-fields into tables containing 'categories' of
fields.
* 'textual' (or informational) fields would be the main 'item' table
* 'quantity' and other 'numeric' fields that are updated frequently (i.e.
quantity sold, quantity on-hand) would be in the table that wou
