William Garrison wrote:
I've never worked with a database with arrays, so I'm curious what the
advantages and disadvantages of using it are. For example:
I am prejudiced against arrays because they violate the relational model. I do
not see an advantage over a related table.
Arrays seem to
William Garrison wrote:
> I've never worked with a database with arrays, so I'm curious...
>
> + Efficiency: To return the set_ids for an Item, I could return an array
> back to my C# code instead of a bunch of rows with integers. That's
> probably faster, right?
You should look in to the contri
I've never worked with a database with arrays, so I'm curious what the
advantages and disadvantages of using it are. For example:
-- METHOD 1: The "usual" way --
Items table:
item_id int,
item_data1 ...,
item_data2 ...
Primary Key = item_id
ItemSet table: <-- Join table
item_id int,
