List:General Discussion« Previous MessageNext Message »
From:florian Date:November 17 2001 7:23pm
Subject:width and height performance
View as plain text  
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
----------


or

mytable
----------
someId
elementNum int(2)
elementValue int(1)
----------

is it better to have 800 000 rows with 21 columns or 160 000 000 rows 
with 3 columns?


thanks alot! =)


best,
florian




Thread
width and height performanceflorian17 Nov
  • Re: width and height performanceDan Nelson17 Nov
  • Re: width and height performanceCarl Troein17 Nov