Subject | Table with 20 million records? |
---|---|
Author | Myles Wakeham |
Post date | 2004-08-28T03:32:22Z |
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
===========================
Myles Wakeham
Director of Engineering
Tech Solutions Inc.
Scottsdale, Arizona USA
Phone (480) 451-7440
Web: www.techsol.org
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
===========================
Myles Wakeham
Director of Engineering
Tech Solutions Inc.
Scottsdale, Arizona USA
Phone (480) 451-7440
Web: www.techsol.org