1. It's faster then SQL Server 2. It's not bloatware like most other DBs out there. 3. It's free for personal AND commercial use 4. Tons of free DB management applications. Thats all the advantages I can think of.. now for the disadvantages There are hardly
any free fully usable data providers out there. ODBC is available but very slow, and parameters and strings combo do not work with the SET command. The prices for the non-free data providers range from $29 - $$$ and some of them do not even work correctly.
I am currently using ODBC, but may need to switch due to the above issues. Haven't found any free fully working mysql data providers. I may end up paying for a fully working provider, once I find one :) Oh, mySQL is missing stored procedures, these will be
added in the next major version (5.0). And it is not 100% SQL compatible, but I havent found a DB yet that is 100% compatible :) Besides the above, mySQL is quite good.
I also only use MySQL with ASP/ASP.NET, I have to say that ODBC is fast enough for most instances, unless you deal with million row dbs, in which case you better off with MySQL/InnoDB and a dedicated data provider driver, also to speed up ODBC in case you use
it, it's good pratice to array the recordset, and close it imediatly after, then just return data from the array, this works quite well and it's faster then retrieving values from the recordset it-self. Shannara > If you find any good and reasonable priced
data provider, let us know, I will also buy a couple of them to test and will post my findings here. Thanks.
No problemo, the ones listed on mysql.com are pretty much crap. Even the ones listed on these forums. It's just aweful. The speed of ODBC doesnt bother me much as I'm doing this VIA web w/ a powerfull enough machine. What gets me is the SET bug in ODBC. It
pretty much renders ODBC worthless for any kind for forum/news script software.. bah.
this is an interesting reading http://sql-info.de/mysql/gotchas.html for the ones that like MySQL. I've switched to FirebirdSQL a long time ago and after reading thisI'm glad I did...
fetcher: Maybe you can help me. I wanted use FirebirdSQL too, since i going use my own computer as web server, so i can alow myself use what ever technology i want. Righ now i have it installed on my computer and i want start use it. But i had problems:
1. I didnot found default login and pass for Firebird. 2. I didnot found any programs for manage Firebird databases and actualy work with it, something like sqlfront for mysql. Can you maybe tell me what to do ?
Hi, I've been using the 1.5 release candidates of Firebird and the default login and pass are: SYSDBA and masterkey. To manage the Firebird I use the free personal edition of IBExpert
http://www.ibexpert.com The final release of Firebird is almost getting out(so they say..), so download it and read the documentation because it explains lots of stuff. The .NET Data provider for Firebird is also very good.
You can subscribe to its newsgroup in news.atkin.com and any problem you may have you can be sure you will have a reply from the person that is actually making the provider. I think it's very cool. I hope this helps
Cant edit posts :( Anyways, I havet found a decent way to connect to firebird via VB6 either. They all use ODBC DSN connection, which everybody knows, is slow as hell. Direct connections (DSN-less) is the best way to go when speed is important... do you know
of any way to connect, DSN-LESS?
modnewbie
Member
85 Points
17 Posts
Any advantage in using Mysql?
Nov 04, 2003 10:36 AM|LINK
Shannara
Member
425 Points
85 Posts
Re: Any advantage in using Mysql?
Nov 05, 2003 04:36 AM|LINK
theSCIENTIST
Member
95 Points
19 Posts
Re: Any advantage in using Mysql?
Nov 15, 2003 09:46 AM|LINK
Shannara
Member
425 Points
85 Posts
Re: Any advantage in using Mysql?
Nov 20, 2003 04:32 PM|LINK
vergilius
Member
430 Points
86 Posts
Re: Any advantage in using Mysql?
Nov 24, 2003 03:57 AM|LINK
fetcher
Member
635 Points
127 Posts
Re: Any advantage in using Mysql?
Nov 24, 2003 03:09 PM|LINK
vergilius
Member
430 Points
86 Posts
Re: Any advantage in using Mysql?
Nov 24, 2003 03:36 PM|LINK
fetcher
Member
635 Points
127 Posts
Re: Any advantage in using Mysql?
Nov 24, 2003 05:02 PM|LINK
Shannara
Member
425 Points
85 Posts
Re: Any advantage in using Mysql?
Nov 24, 2003 08:08 PM|LINK
Shannara
Member
425 Points
85 Posts
Re: Any advantage in using Mysql?
Nov 24, 2003 08:35 PM|LINK