florian writes:
> i have to store a dataset of 20 elements. the data is a int(1).
> i would have about 800 000 datasets. now the question is what performs better
> with mysql?
>
> is it better to have 800 000 rows with 21 columns or 160 000 000 rows
> with 3 columns?
That's 16M rows, not 160
In the last episode (Nov 17), florian said:
> i have to store a dataset of 20 elements. the data is a int(1). i
> would have about 800 000 datasets. now the question is what performs
> better with mysql?
>
> one table like this: or:
>
> mytable mytable
> -
hi!
i have to store a dataset of 20 elements. the data is a int(1).
i would have about 800 000 datasets. now the question is what performs better
with mysql?
one table like this:
mytable
--
someId
element1 int(1)
element2 int(1)
element3 int(1)
element4 int(1)
...
element20
--
