Subject RE: [ib-support] Re: time series and FB/IB
Author Richard Pendered
Firebird can cope with a lot of rows.
In one of my dbs, i have a few tables, one has 20,780,656 rows and another
77,638,974 rows and both are indexed.

-----Original Message-----
From: Svein Erling Tysvaer
Sent: 11 December 2002 08:39
Subject: Re: [ib-support] Re: time series and FB/IB

I would expect Fb/IB to handle such a table (it is nowhere near 2^64, it is
even below 2^32), but I have no experience with anything that size.


At 14:56 10.12.2002 +0000, you wrote:
>I'll try both aproaches and will see the results.
>Another question which comes to my mind is this data table structure:
>pk integer,
>series_id integer, (FK)
>time timestamp,
>value double precision
>This would result in table with 350 000 000 rows and very fast
>growing (45 000 000 row/year). Can FB/IB handle such tables?

To unsubscribe from this group, send an email to:

Your use of Yahoo! Groups is subject to