Subject Re: [firebird-support] Table with 20 million records?
Author Dan Wilson
On 8/27/2004 at 8:32 PM Myles Wakeham wrote:

> I have an associate who is looking at storing about 20 million rows in a
> single table in MySQL. He's concerned about performance. I would like to
> suggest to him that Firebird may be a better option for his needs, but
> wanted to know if anyone has any Firebird database with a table with this
> level of data in it? If so, how are you finding performance at this
> level?
> Myles

I have a database that is currently just over 60GB. The largest table has 214 million rows. Two other tables have a total of 127 million records between them(I am looking at the primary key generator value which is shared between those two tables). I have learned to be VERY careful with the commands I issue: "select count(*)" is a bad bad bad thing to do.... However, with carefully constructed queries and indices, retrievals range from very quick (sub-second accesses) to slow but livable (a few minutes to find and retrieve a few thousand rows out of 214 million).