Board index » delphi » MSDE or MySQL

MSDE or MySQL


2004-11-22 11:05:50 PM
delphi191
Hi there!
We have a application that uses Interbase 6.0 (free version), we are
expecting move it to another 'free' database platform. I know that the MySQL
is not actually free, but seems that it is cheaper than Interbase (am I
right?). The other option is use MSDE.
Other question is: I am trying MySQL 4.1.7 with the ODBC driver in my delphi
5 application, as I ever used it (mysql), how is the general performance
with ODBC, and how the the transaction control works. Can I use ODBC or
should I get other way to connect the database?
I would appreciate any sugestions and/or tips. Thanks a lot.
Magno
 
 

Re:MSDE or MySQL

Hi,
Quote
We have a application that uses Interbase 6.0 (free version), we are
expecting move it to another 'free' database platform. I know that the MySQL
is not actually free, but seems that it is cheaper than Interbase (am I
right?). The other option is use MSDE.

Other question is: I am trying MySQL 4.1.7 with the ODBC driver in my delphi
5 application, as I ever used it (mysql), how is the general performance
with ODBC, and how the the transaction control works. Can I use ODBC or
should I get other way to connect the database?

I would appreciate any sugestions and/or tips. Thanks a lot.
Don't forget Firebird as suggestion. It is based on Interbase-OE and has many new features and
bug-fixes. The migrate would become much easier and Firebird is for free. See bottom of this message
for links.
Regards,
Arno Brinkman
ABVisie
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Firebird open source database (based on IB-OE) with many SQL-99 features :
www.firebirdsql.org
www.firebirdsql.info
www.fingerbird.de/
www.comunidade-firebird.org/
Support list for Interbase and Firebird users :
XXXX@XXXXX.COM
Nederlandse firebird nieuwsgroep :
 

Re:MSDE or MySQL

Magno writes:
Quote

We have a application that uses Interbase 6.0 (free version), we are
expecting move it to another 'free' database platform. I know that
the MySQL is not actually free, but seems that it is cheaper than
Interbase (am I right?). The other option is use MSDE.
MSDE is fully featured - it is really MS SQL - but it is deliberately governed
so that it performs badly with more than 5 concurrent connections.
MySQL does not have a governor, but is not a fully featured sql server - no
stored procs or triggers and many other things.
Why the move from InterBase?
--
Wayne Niddery - Logic Fundamentals, Inc. (www.logicfundamentals.com)
RADBooks: www.logicfundamentals.com/RADBooks.html
SpaceShipOne; GovernmentZero
 

Re:MSDE or MySQL

Hi Arno,
It´s ok about Firebird as an option, it is not out of the game, but as my
company had experiencied some problems with the old 6.0 Interbase we are
just trying to see the other existents options, such as very slow database
access with it as litlle as 400Mb (and without no more the 15 columns in the
main, and bigger table), which force us to stop/start the Ib server
frequently and start from the zero a new database :( . Btw, how does
Firebird works with transactions? Is that symptom seem with Firebird?
Thank you very much!
Magno
"Arno Brinkman" <bnewsgroups @ REMOVE_ME abvisie.nl>escreveu na mensagem
Quote
Hi,

>We have a application that uses Interbase 6.0 (free version), we are
>expecting move it to another 'free' database platform. I know that the
MySQL
>is not actually free, but seems that it is cheaper than Interbase (am I
>right?). The other option is use MSDE.
>
>Other question is: I am trying MySQL 4.1.7 with the ODBC driver in my
delphi
>5 application, as I ever used it (mysql), how is the general performance
>with ODBC, and how the the transaction control works. Can I use ODBC or
>should I get other way to connect the database?
>
>I would appreciate any sugestions and/or tips. Thanks a lot.

Don't forget Firebird as suggestion. It is based on Interbase-OE and has
many new features and
bug-fixes. The migrate would become much easier and Firebird is for free.
See bottom of this message
for links.

Regards,
Arno Brinkman
ABVisie

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Firebird open source database (based on IB-OE) with many SQL-99 features :
www.firebirdsql.org
www.firebirdsql.info
www.fingerbird.de/
www.comunidade-firebird.org/

Support list for Interbase and Firebird users :
XXXX@XXXXX.COM

Nederlandse firebird nieuwsgroep :
news://newsgroups.firebirdsql.info


 

Re:MSDE or MySQL

Hi Wayne,
As i told to Arno, the main problem with Interbase 6 is that the server
becomes very very slow in the past of time, and we need to restart it
frequently, and to get wrost sometimes we need to zero all the database.
To you be able to understand, we have a table with about 15 fields, we
receive constantly information that must be inserted on it, the number of
rows grows up to 300,000 or 400,000 and the Interbase server must but
reseted :( -- I mean: use a new empty gdb file. And the start/stop is done
about once, day by day.
Thank you!
Magno
"Wayne Niddery [TeamB]" <XXXX@XXXXX.COM>escreveu na mensagem
Quote
Magno writes:
>
>We have a application that uses Interbase 6.0 (free version), we are
>expecting move it to another 'free' database platform. I know that
>the MySQL is not actually free, but seems that it is cheaper than
>Interbase (am I right?). The other option is use MSDE.

MSDE is fully featured - it is really MS SQL - but it is deliberately
governed
so that it performs badly with more than 5 concurrent connections.

MySQL does not have a governor, but is not a fully featured sql server -
no
stored procs or triggers and many other things.

Why the move from InterBase?

--
Wayne Niddery - Logic Fundamentals, Inc. (www.logicfundamentals.com)
RADBooks: www.logicfundamentals.com/RADBooks.html
SpaceShipOne; GovernmentZero


 

Re:MSDE or MySQL

Are you doing all of the inserts in a single transaction? Are you doing
updates at the same time? It is difficult to tell what is causing your
performance problem with the information you have supplied but you need
to find out what the problem is. If you have an application design
problem changing databases will not make it go away.
--
Bill (TeamB)
TeamB cannot answer questions received via email
 

Re:MSDE or MySQL

Interbase can be very slow if you dont optimise the queries. This can be
painful because I have found you need to write fairly non-standard SQL
(forget left joins) to get it to run well, but once done, it is pretty
quick.
Quote
It´s ok about Firebird as an option, it is not out of the game, but as my
company had experiencied some problems with the old 6.0 Interbase we are
just trying to see the other existents options, such as very slow database
access with it as litlle as 400Mb (and without no more the 15 columns in
the
main, and bigger table), which force us to stop/start the Ib server
frequently and start from the zero a new database :( . Btw, how does
Firebird works with transactions? Is that symptom seem with Firebird?

 

Re:MSDE or MySQL

Magno writes:
Quote

As i told to Arno, the main problem with Interbase 6 is that the
server becomes very very slow in the past of time, and we need to
restart it frequently, and to get wrost sometimes we need to zero all
the database.
This indicates a problem handling transactions in your application(s). At
the point when IB is running very slow, dump the header stats and see what
the gap is between oldest active and next transaction numbers, and also the
oldest snapshot. It is almost certain this could be fixed to give you
acceptable performance.
--
Wayne Niddery - Logic Fundamentals, Inc. (www.logicfundamentals.com)
RADBooks: www.logicfundamentals.com/RADBooks.html
"The only reason some people get lost in thought is because it's
unfamiliar territory." - Paul Fix
 

Re:MSDE or MySQL

MSDE is a good choice, fast,stable with very powerfull 'Transact SQL'
scripting language. The limitation of 5 concurrent users might be a
problem, if concurrent load from more than 5 clients is heavy.
If MSDE is used, you should look for a licence of the
'enterprise-manager' as an admin frontend.
However there may be a licence problem: MSDE is free if delivered
together with applications created by MS-Products like VisualStudio :-(
MYSQL is something what I'd hardly call a grown up database. If you
have some data to be managed on a webserver, it is good together with
PHP language. I'd never use it in a serious client-server application.
Heinrich
Magno writes:
Quote
Hi there!

We have a application that uses Interbase 6.0 (free version), we are
expecting move it to another 'free' database platform. I know that the MySQL
is not actually free, but seems that it is cheaper than Interbase (am I
right?). The other option is use MSDE.

Other question is: I am trying MySQL 4.1.7 with the ODBC driver in my delphi
5 application, as I ever used it (mysql), how is the general performance
with ODBC, and how the the transaction control works. Can I use ODBC or
should I get other way to connect the database?

I would appreciate any sugestions and/or tips. Thanks a lot.

Magno



 

Re:MSDE or MySQL

Thank you Heinrich! I just read about that... Yes, both MySQL and MSDE
cannot fit to our necessities... we are going for Firebird.
Magno
"Heinrich Braun" <XXXX@XXXXX.COM>escreveu na mensagem
Quote
MSDE is a good choice, fast,stable with very powerfull 'Transact SQL'
scripting language. The limitation of 5 concurrent users might be a
problem, if concurrent load from more than 5 clients is heavy.
If MSDE is used, you should look for a licence of the
'enterprise-manager' as an admin frontend.
However there may be a licence problem: MSDE is free if delivered
together with applications created by MS-Products like VisualStudio :-(



MYSQL is something what I'd hardly call a grown up database. If you
have some data to be managed on a webserver, it is good together with
PHP language. I'd never use it in a serious client-server application.

Heinrich








Magno writes:
>Hi there!
>
>We have a application that uses Interbase 6.0 (free version), we are
>expecting move it to another 'free' database platform. I know that the
MySQL
>is not actually free, but seems that it is cheaper than Interbase (am I
>right?). The other option is use MSDE.
>
>Other question is: I am trying MySQL 4.1.7 with the ODBC driver in my
delphi
>5 application, as I ever used it (mysql), how is the general performance
>with ODBC, and how the the transaction control works. Can I use ODBC or
>should I get other way to connect the database?
>
>I would appreciate any sugestions and/or tips. Thanks a lot.
>
>Magno
>
>
>
 

Re:MSDE or MySQL

Quote
However there may be a licence problem: MSDE is free if delivered
together with applications created by MS-Products like VisualStudio :-(
That's no longer true. it is now a free download from MSDN.
 

Re:MSDE or MySQL

Don Siders writes:
Quote
>However there may be a licence problem: MSDE is free if delivered
>together with applications created by MS-Products like VisualStudio :-(


That's no longer true. it is now a free download from MSDN.

Yes, the download is free, but ...
www.microsoft.com/germany/ms/sql/2000/msde.htm
at least in german it says something like:
...
Sie können die in der folgenden Tabelle aufgeführten
Microsoft-Anwendungen verwenden, um Anwendungen zu erstellen, die MSDE
2000 als Datenspeicher verwenden. Weiterverteilungsrechte und
Richtlinien werden im Endbenutzerlizenzvertrag (End User License
Agreement, EULA) des jeweiligen Produkts definiert.
...
roughly translated :
you may use the programs mentioned in table below to create an
application which uses MSDE as data storage...
further
Die Lizenzierung für MSDE 2000 ist unterschiedlich und richtet sich nach
der Anwendung, in die das Produkt integriert wurde.
The licencing depends on the application, in which MSDE is itegrated ...
Heinrich
P.S. may be its different in different countries?
 

Re:MSDE or MySQL

Quote
>>However there may be a licence problem: MSDE is free if delivered
>>together with applications created by MS-Products like VisualStudio :-(
www.microsoft.com/germany/ms/sql/2000/msde.htm
roughly translated :
you may use the programs mentioned in table below to create an
application which uses MSDE as data storage...
The licencing depends on the application, in which MSDE is itegrated ....
P.S. may be its different in different countries?
Could be... but I doubt it. it is more likely that the German site simply has the verbage from the old license. See www.microsoft.com/sql/msde/howtobuy/msdeuse.asp.