Sorry, I should not have top-posted (Dang iPhone). Continued below:
On 04/20/2014 05:54 PM, Dorian Hoxha wrote:
Because i always query the whole row, and in the other way(many tables) i will always join + have other indexes.
Interesting. Of course any decent mapper will return "the whole row". And would it be less disk intensive as an array of "struct ( where struct is implemented as an array)". From other threads [1] [2] I've come to understand the datatype overhead per native type will be applied per type instance per array element.
[1]
30K floats [2]
char array