Re: [GENERAL] Arrays instead of join tables

2007-04-02 Thread Lew
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

Re: [GENERAL] Arrays instead of join tables

2007-04-01 Thread Ron Mayer
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