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 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
