Re: Inputting columns of data

On Monday 16 February 2004 17:16, C G wrote:
> >On the other hand, that's a poor way of using a relational database - can
> >you
> >explain what you are trying to achieve? Someone might have a better way to

> I'm using the database to store results from a numerical simulation, so the
> first column of the data array would be 'time', then the next column(s)
> would be population(s). There are about 1000 rows in each array.
>
> I about thought putting each row of the array into a row in the table.
> However, this could very quickly lead to a table with more than a million
> rows. Would this be a problem?

Well PG will handle that quantity of data comfortably, but without knowing
your performance requirements and hardware it's difficult to estimate speed.

I'd recommend putting together a test - I usually regret compromising design
for performance.

--
  Richard Huxton
  Archonet Ltd