Maximum # of Columns

2001-11-10 Thread Sparta Cruz
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

Re: Maximum # of Columns

2001-11-10 Thread Rodney Broom
From: Sparta Cruz [EMAIL PROTECTED] Do you think this was due to software constraints(MySQL), or do you think it had to do with hardware constraints? I'm sure it was software. Possibly the MyISAM tables I'm using. -Original Message- From: Rodney Broom [mailto:[EMAIL PROTECTED]]

RE: Maximum # of Columns

2001-11-10 Thread Carsten H. Pedersen
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

RE: Maximum # of Columns

2001-11-10 Thread Ernie Hershey
columns and 80 rows). Ernie Hershey [EMAIL PROTECTED] -Original Message- From: Sparta Cruz [mailto:[EMAIL PROTECTED]] Sent: Saturday, November 10, 2001 3:10 PM To: [EMAIL PROTECTED] Subject: Maximum # of Columns am trying to design a good database, that has a matrix of data per record

RE: Maximum # of Columns

2001-11-10 Thread Ernie Hershey
be stored in a given program anyways, so it would be more organized. Ernie Hershey [EMAIL PROTECTED] -Original Message- From: Sparta Cruz [mailto:[EMAIL PROTECTED]] Sent: Saturday, November 10, 2001 3:48 PM To: Ernie Hershey Subject: RE: Maximum # of Columns This doesn't have