I have a couple of databases with 20 million + rows in 2 or 3 tables linked
by indexed double precision fields. I have not needed to link them with a
foreign key constraint. I have PK's on double precision fields in each of
the tables. As far as speed goes, lookups on 2 joined tables takes about
0.062 seconds. Fetching 10K-100K records at a time takes me about 8-30
seconds.

-----Original Message-----
From: Jannie Nel [mailto:Jannie@...]
Sent: Thursday, February 17, 2005 9:17 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Large volumes of data



Hi,

I have a newbie question:

Does anyone have experience in using Firebird with large volumes of
data? Large being around 100 million rows in table B that has a
referential integrity constraint to table A that has 30 million rows.

Any input welcome.

TIA.

Jannie.

P.S. My apologies to those who also belong to the tiOPF mailing list who
have received this message again.




Yahoo! Groups Links