46 messages in com.mysql.lists.mysqlRe: MySQL or MaxDB or PostgreSQL or I...
FromSent OnAttachments
Jerry Apfelbaum14 Dec 2003 11:59 
Vinod Kumar Singh15 Dec 2003 03:15 
Sven Köhler15 Dec 2003 04:50 
Joshua Thomas15 Dec 2003 05:04 
Martijn Tonies15 Dec 2003 05:05 
Chris Nolan15 Dec 2003 06:10 
Sven Köhler15 Dec 2003 06:16 
Sven Köhler15 Dec 2003 06:26 
Chris Nolan15 Dec 2003 06:31 
Martijn Tonies15 Dec 2003 06:38 
Juergen Sauer15 Dec 2003 06:44 
Chris Nolan15 Dec 2003 06:52 
Tobias Asplund15 Dec 2003 06:53 
Chris Nolan15 Dec 2003 07:10 
Martijn Tonies15 Dec 2003 07:25 
Chris Nolan15 Dec 2003 07:40 
Martijn Tonies15 Dec 2003 07:48 
Matthew Stanfield15 Dec 2003 10:26 
Curtis Maurand15 Dec 2003 13:59 
Chris Nolan15 Dec 2003 15:52 
Chris Nolan15 Dec 2003 15:54 
Jeremy Zawodny15 Dec 2003 17:13 
David Garamond15 Dec 2003 21:01 
Jeremy Zawodny15 Dec 2003 22:53 
Chris Nolan15 Dec 2003 23:24 
Martijn Tonies16 Dec 2003 00:07 
Dr. Frank Ullrich16 Dec 2003 01:49 
Chris Nolan16 Dec 2003 03:17 
Matthew Stanfield16 Dec 2003 05:32 
Matthew Stanfield16 Dec 2003 05:45 
Chris Nolan16 Dec 2003 06:01 
David Griffiths16 Dec 2003 08:36 
Chris Nolan16 Dec 2003 08:50 
David Griffiths16 Dec 2003 09:43 
mos16 Dec 2003 13:52 
Martijn Tonies16 Dec 2003 14:07 
Chris Nolan16 Dec 2003 17:14 
mos16 Dec 2003 21:10 
Martijn Tonies16 Dec 2003 23:46 
Matthew Stanfield17 Dec 2003 04:35 
Ed Leafe17 Dec 2003 04:55 
ja...@rogers.com17 Dec 2003 09:00 
mos17 Dec 2003 21:27 
Martijn Tonies18 Dec 2003 00:33 
Martijn Tonies07 Jan 2004 07:21 
Director General: NEFACOMP07 Jan 2004 07:23 
Subject:Re: MySQL or MaxDB or PostgreSQL or Interbase/Firebird or ?
From:mos (mos@fastmail.fm)
Date:12/16/2003 01:52:18 PM
List:com.mysql.lists.mysql

At 01:59 PM 12/14/2003, you wrote:

Hello.

I have been tasked with evaluating open source databases for a large upcoming project: e-commerce, B2B, high availability.

The O/S is most likely to be Linux, although FreeBSD could possibly be used (lower probability).

So far, it seems that MySQL, MaxDB, PostgreSQL, and Interbase/Firebird are possible candidates.

Does anyone know why we should or should not use any of these? Does anyone know of other possibilities?

I'd very much appreciate hearing your comments and recommendations.

I have only recently started these evaluations. BTW, my own background is from the Oracle DBA world.

MySQL is certainly popular and seems to have very good performance, but I am concerned that the lack of Triggers, Stored Procedures, User-Defined Functions, and Views (to a lesser degree ) will be a disadvantage.

MaxDB "appears" to be more feature-rich and possibly more industrial-strength. How does its performance and stability compare to the others?

Many Thanks. Jerry Apfelbaum Toronto

Jerry, Interbase/Firebird looks good on paper. But there are a couple of things to watch out for.

1) Check the Borland Interbase newsgroups for "corruption" to see if it is still an issue. I know from reading their newsgroups a few years back , there were quite a few postings. It could of been due to inadequate hardware or some external source like a misconfigured server or power failure. There are many sites that use IB without such problems but it is worth checking it out (especially how to successfully repair a damaged IB/FB database because all the tables are stored in one file).

2) Speed problems. I don't know how much data your tables will have, but IB/FB has a habit of slowing down as more rows are added/deleted. They have an automated Sweep process that cleans out the updated/deleted rows (deleted & updated rows still take up space until the database is swept). Even so a large db will still slow down. I suspect the problem is due to unbalanced indexes. The only way to fix it is to unload all your data and reload it back in. Some people do it once a week.

3) The server CPU load will increase rapidly after the first 5 or 6 users. In other words IB/FB requires a much faster CPU than the same number of users for MySQL. It is a very CPU intensive DB server. There was an earlier problem with IB Super Server not running well on multiple processors (it actually slowed things down). I believe this has been fixed in IB version 6.5. I don't know if this was fixed in FB because FB may be running IB Classic (single processor) version.

Mike