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
[mailto:svein.erling.tysvaer@...]
Sent: 11 December 2002 08:39
To: ib-support@yahoogroups.com
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.

Set

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:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/