Quote:
|
Originally Posted by bstjean
Yes and what's the problem with that? I have 3 servers (Win 2K, Win XP and Linux) with 50 databases with a dozen tables over 60 million rows all handled smoothly with InnoDb. *Some* features (like fulltext search) are only available with MyISAM but guess what, do you have fulltext search with Firebird ?
I am not saying one is better than the other (By the way, DB2 addict here)! I am just saying MySQL can handle the load properly (see Yahoo Finance, Genome project and lots of other examples) and it has a very active community and lots of resources/addons/documentation on the web. That can't be compared to what the Firebird community has to offer.
Need to do some Perl/ASP/PHP/Java/C##/ VB with MySQL? You can find a zillion links/forums/mailing lists! I don't think Firebird is as popular as MySQL.
Yes they promise lots of new stuff every release but at least it shows that the product is well and alive and that lots of development is underway. Can you say the same thing about Firebird? Just finding a decent (not to say functionnal) free ODBC driver for Firebird is impossible...
And hey, stop talking about " PR flacks" when your RDBMS is only at version 1.5 and has prooved nothing in a real production environment. MySQL has *shown* it can be used in real life.
My 2 cents.
|
Some other forum i hear that yahoo still use old version of mysql, besides they are big and can afford the mysql support fee. We pay hundred's of dollars to buy MySql commercial license while Firebird is free (more free). I don't know how well mysql handle unicode or other collate type.
Also MySql (production)version <= 4.0.x is not real
RDBMS. No foreign key support, recently they have removed the paragraph from documentation which suggested that for database
you don't need foreign keys.
I have used MySql since 2000 and it has *shown* me that its not good for real db intensive applications.
Checkout Firebird's mailing list there you will get free support from the core developers and don't be surprised if you get reply's within minutes.