Subject | RE: [ib-support] Re: time series and FB/IB |
---|---|
Author | Richard Pendered |
Post date | 2002-12-11T12:05:46Z |
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:
ib-support-unsubscribe@egroups.com
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
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.To unsubscribe from this group, send an email to:
>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?
ib-support-unsubscribe@egroups.com
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/