| 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 performance | florian | 17 Nov |
| • Re: width and height performance | Dan Nelson | 17 Nov |
| • Re: width and height performance | Carl Troein | 17 Nov |
