RE: Maximum # of Columns

2001-11-10 Thread Ernie Hershey
ld 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

RE: Maximum # of Columns

2001-11-10 Thread Ernie Hershey
Why not just use 43 db rows each with 80 fields and a matrix row index field? Then 350 records with 80x43=3440 fields turns into 350x43=15050 records with 81 fields, which is much more manageable. PS - Does this table happen to be for recording the contents of a text window? (43 columns

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

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 PROTE