Re: Would User Defined Type(UDT) nested in a LIST collections column type give good read performance

2017-10-30 Thread Bill Walters
Hi DuyHai, Thank you for providing your feedback to our question. Just to elaborate on the 2 factors that you have provided above. 1) Collection cardinality e.g. the number of elements in the collection. A maximum of 64,000 elements can be stored. 2) the size of each element in the collection. T

Re: Would User Defined Type(UDT) nested in a LIST collections column type give good read performance

2017-10-30 Thread DuyHai Doan
Hello Bill First if you don't care about insertion order it's better to use Set rather than list. List implementation requires read before write for some operations. Second, the read performance of the collection itself depends on 2 factors : 1) collection cardinality e.g. the number of elements

Would User Defined Type(UDT) nested in a LIST collections column type give good read performance

2017-10-29 Thread Bill Walters
Hi Everyone, We need some help in deciding whether to use User Defined Type(UDT) nested in LIST collection columns in our table. In a couple of months, we are planning to roll out a new solution that will incorporate a Read heavy use case. We have one big table which will hold around 250 million