ZDNet UK


Skip to Main Content

ZDNet.co.uk - Winner of Best Business Website 2007
  1. Home
  2. News
  3. Blogs
  4. Reviews
  5. Prices
  6. Resources
  7. Community
  8. My ZDNet

 

ZDNet UK RSS Feeds


IT Jobs

Office applications Toolkit

Story: MySQL and Firebird battle for database top spot

  • Previous comment

Posted by: Anonymous (Monday 30 January 2006, 9:24 PM)

  • Reply

id they do this survey on the firebird site? In my experience most people havn't even heard about Firebird.

MySQL AB is much better at marketing than producing a good database. Both Firebird and even more so Postgresql are far better products than MySQL. MySQL AB tells you that MySQL 5 is the fastest database around and that it now have all the features that real databses have, such as triggers, stored procedures, transactions...

The problem is that they don't tell you that you have to turn off all the nice features that postgresql have to get the speed. Even if you turn it all off Postgresql still beats them on speed as soon as the queries get slightly more complicated than "select * from table" or you have many simultaneous users. To make things even worse the lack of features in the MySQL SQL language often makes the queries more complex and inelegant. Just imagine doing a relaional division without the "except" keyword.

The lack of feature in the MySQL language also makes it much harder to port code written for other databases.

  • Previous comment

  • Reply to this comment
  • Return to story
  • Report this as offensive


Full Talkback thread


Featured Talkback

Why do so many (virtually all) software packages think that they are so important that they have to be started automatically every time the computer boots? What is the largest number of "speed access", "update check", "camera download" and whatever other background programs you have ever seen running? Of those, how many did you really need?

By: J.A. Watson

Read full story:
Annoying software: a rogues' gallery

Discussions

stl_saint stl_saint

long time coming....

Thursday 21 August 2008, 3:47 AM

1 comment

Vista Upgrade Blog

Official MS Windows 7 Bloggers

Check this out: http://blogs.msdn.com/e7...spx Its an official blog "Engineering Windows 7" Nothing. That's what is revealed. Until there is real... More

4 comments

Microsoft's Mojave just a desert vista

It didn't seem fair to wade into Microsoft's “Mojave Experiment” advert quite so soon after the flat earth incident. But The Economist has no such qualms: in this week's issue, it wonders... More

6 comments

... But Still a Few Things Amiss (with...

It's not all roses with Vista, of course. I had my first BSOD over the weekend, when I was turning the laptop back on after suspending it. They typical long blurb about "If this is... More

6 comments