Ang:

Pardon me for my 2cents, but I have used both MySQL and IB, so I
figure I can answer your questions.

MySQL is quite fast, but that is because most of the features that
would slow it down, are missing. The last time I looked at MySQL
(last September/October) it had no support for triggers, stored
procedures or views. Referential integrity and foreign keys exist so
the parser doesn't choke, but don't do anything.

The biggest concern I had with it, had to do with the licensing, it's
extremely confusing, in some cases it's GPL, in other cases it isn't
and requires that you pay support fees, and in still other cases that
you pay royalties on top of the support fees. I read the licence
through a number of times, and it still wasn't clear.

Now as for speed, it's a non-issue, you need to size the database
server properly, to get the performance level you want. MySQL might
have a slightly faster engine, but you don't have triggers and
stored procedures, which means you can't run some database operations
on the server, and that means more load on the client and network.

Paul

On 21 Mar 2001, at 14:10, Ang Lik Huar wrote:

To: <IBObjects@yahoogroups.com>
From: "Ang Lik Huar" <lhang@...>
Date sent: Wed, 21 Mar 2001 14:10:17 +0800
Send reply to: IBObjects@yahoogroups.com
Subject: [IBO] IBO + Interbase <-> dbExpress + MySQL

> Jason,
>
> What is the pro & con for the above combination regarding
> flexibility,speed,compability, expense .. etc ???
>
> I think the dbExpress + MySql that come with Kylix (or also Delphi 6
> ??) will make a lot of ppl switch to that area.
>

Paul Schmidt,
Tricat Technologies
Email: paul@...
Website: www.tricattechnologies.com