> am trying to design a good database, that has a matrix of data > per record. > For example, 1 record already has 80x43 = 3440 datafields which > each need to > hold real numbers. The way I would do it would be to hold a row of 3440 > columns, but I do not know if that will be a mistake or if that > would be the > best way of doing it. I could store each matrix in a file, but how > efficient would that be. Also, I have never created 3440 columns on a > database, but it does sound awkward especially given the fact that there > will only be 350 records. >
You're pushing a bit past the limits... http://www.bitbybit.dk/mysqlfaq/faq.html#ch9_5_0 / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq --------------------------------------------------------------------- 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