Quote:
Originally posted by Victorious
Hello everyone,
I'm currently working on a medium-sized website, including a store and 'regular' news / article / commenting features. The company me and my team are creating this site for also has a real-life store, which will have software running on it's consoles that queries the same database used by the website, for product information and such.
Up until now we've been developing the website using MySQL as a database solution, but recently the team that's developing the software for the real-life store has brought up the idea to switch to a database server called Firebird - http://firebird.sourceforge.net/
I couldn't find any benchmarks or featurelists on that website, nor could I find feature comparisons and benchmark-comparisons with Firebird on the MySQL site. Ofcourse I'm dying to know which database is the better choice. The team that's developing the software claims that Firebird is more reliable when there are a lot of users quering the database.
Could anyone tell me more about the cons and pros of Firebird in relation to MySQL? Thanks in advance!
p.s.: English is not my native language so I apologise for any errors
|
Here's a quick list of what I could come up with...
MySQL has a much larger community and support than Firebird has.
Firebird *terribly* lack good ODBC support... None of the drivers I've tried so far worked... And the ones that worked "best" were pretty expensive.
If you don't need transactions (e.g. just feed your website for display from MySQL), the only known database that is faster than MySQL is Oracle...
MySQL is supported on a zillion platforms.
MySQL has lots of documentation for PHP, ASP, etc support...
You'll find more people that know MySQL than Firebird specialists.
If you're doing lots of DELETE, performance on Firebird will degrade a lot faster than MySQL (see sweep operation).
BTW, I am not doing propaganda for MySQL, I'm a DB2 fan!