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
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
> 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
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