StumpedAndGrateful
asked on
Best Performing Free DB
I am looking at what database to use for my application. I am particularly interested in the number of concurrent connections allowed and the speed at which the database will perform. I had been looking at MySQL and MS SQL Server 2008 Express. Does anybody have any recommendations?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for the quick response!
A few further questions:
1) What does power vs. speed mean, as far as databases are concerned? I'm a novice as you can see.
2) Am I correct in understanding that you think MySQL is slower than MS SQL Server?
3) If I use MS SQL Server Express, I am probably going to divy out one database into several, so that they stay under the 10 GB limit. Are there going to be performance related issues from constantly having tables in different databases joined, etc? Will this slow down SQL Server enough that I should re-consider MySQL?
A few further questions:
1) What does power vs. speed mean, as far as databases are concerned? I'm a novice as you can see.
2) Am I correct in understanding that you think MySQL is slower than MS SQL Server?
3) If I use MS SQL Server Express, I am probably going to divy out one database into several, so that they stay under the 10 GB limit. Are there going to be performance related issues from constantly having tables in different databases joined, etc? Will this slow down SQL Server enough that I should re-consider MySQL?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
>>KeremE: Oracle does not have a free version but both BerkelyDB and MySQL are in Oracle's portfolio now
Oracle Express edition is completely free.
Oracle Express edition is completely free.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
>>KeremE: Oracle does not have a free version but both BerkelyDB and MySQL are in Oracle's portfolio now
>Oracle Express edition is completely free.
Oracle Express Edition won't allow you to use it in a produstion environment! You can only use it "internally"
>Oracle Express edition is completely free.
Oracle Express Edition won't allow you to use it in a produstion environment! You can only use it "internally"
>>Oracle Express Edition won't allow you to use it in a produstion environment! You can only use it "internally"
You are misinformed, this is not true.
You are misinformed, this is not true.
Here are the licensing terms of Oracle:
http://download.oracle.com/docs/cd/B25329_01/doc/license.102/b25456/toc.htm
License Rights
We grant you a nonexclusive, nontransferable limited license to use the programs for: (a) purposes of developing, prototyping and running your applications for your own internal data processing operations; (b) you may also distribute the programs with your applications; (c) you may use the programs to provide third party demonstrations and training; and d) you may copy and distribute the programs to your licensees provided that each such licensee agrees to the terms of this Agreement. You are not permitted to use the programs for any purpose other than as permitted under this Agreement. Program documentation is either shipped with the programs, or documentation may accessed online at http://www.oracle.com/technology/documentation/ .
http://download.oracle.com/docs/cd/B25329_01/doc/license.102/b25456/toc.htm
License Rights
We grant you a nonexclusive, nontransferable limited license to use the programs for: (a) purposes of developing, prototyping and running your applications for your own internal data processing operations; (b) you may also distribute the programs with your applications; (c) you may use the programs to provide third party demonstrations and training; and d) you may copy and distribute the programs to your licensees provided that each such licensee agrees to the terms of this Agreement. You are not permitted to use the programs for any purpose other than as permitted under this Agreement. Program documentation is either shipped with the programs, or documentation may accessed online at http://www.oracle.com/technology/documentation/ .
ASKER
Wow! This is all very good info!
I will be creating a client-server desktop application. It sounds like MySQL is the way to go. I am a little intrigued by BerkeleyDB though, since you all said it was the fastest. How does it compare with MySQL?
Thanks!
I will be creating a client-server desktop application. It sounds like MySQL is the way to go. I am a little intrigued by BerkeleyDB though, since you all said it was the fastest. How does it compare with MySQL?
Thanks!
KeremE, you aren't reading the license. You need to read. Specifically (b) and (c) and (d)
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
You guys hit the ball out of the park on this one. I'm going with MySQL. Thanks!
As far as raw speed, I recall that MySQL has some pretty good latencies, but this is due to a limited feature set. Lightweight features = easier to perform.
I've never chosen Oracle or SQL Server for speed, rather power and integrity features.
If you really wanted raw speed then you should look at Berkeley DB / SleepyCat, otherwise, look at the free DB with reasonable speed and the most power.