Hi
Which is generally faster for small web projects - MySQL or Oracle?
Please provide some proof (benchmarks or any other) of your opinion.
+2
A:
MySQL is free and generally great for small projects. Oracle costs you some bills. That's enough for me. You might also consider Postgre for small web projects. Possibly related: http://stackoverflow.com/questions/1788854/when-to-choose-oracle-over-mysql
Typeoneerror
2010-05-31 07:40:37
The Oracle XE is also free for dataset < 2Gb, which is usually just fine for small websites. But why bother with the overhead if you do not need it?
Peter Tillemans
2010-05-31 07:43:39
@PeterTillemans - actually the XE license permits 4GB of user data
APC
2010-05-31 09:27:46
+7
A:
In >90% of cases MySQL. Since most simple websites have simple key-value with some very limited relations and no or limited need for transactions.
Oracle really comes to its right with complicated datamodels requiring tuned SQL queries and high transaction counts.
Peter Tillemans
2010-05-31 07:42:25
@Peter - is there any actual benchmarking proof that fir "simple key value" stuff Oracle is measurably slower?
DVK
2010-05-31 08:32:07
The cost of creating a connection in MySQL is relatively low. In small web projects where users browse fast between pages, this might be a benefit.
Konerak
2010-05-31 08:53:46
I based this on benchmarking I did long ago between MySQL, Postgresql and Oracle. I used at that time ISAM tables and found them to be very fast, but the lack of transactions and (relatively) poor performance on joins were the minusses. Oracle scales much better than either one, but the domain needed to be complaicated and big enough to show it. In the end we decided on postgresql as it was best for our intended purpose. In the mean time a lot of water has passed under the bridge and I really need to redo this test.
Peter Tillemans
2010-05-31 09:44:30
+1
A:
Small web projects are dominated by engineering cost, so I guess you mean installation time. MySQL can be installed faster. And of course both are a bad idea from engineering time pov. A small web project should be able to do without a RDBMS (e.g. Seaside with Sandstone persistence).
In a commercial setting it is a question with little value. There the important thing is to be able to do many projects, and the scalability and interoperability range you want to achieve. That depends on the market you want to be in, the qualifications of the people you work with.
Stephan Eggermont
2010-05-31 07:43:49
+2
A:
yes probably MySQL. For small projects I think SQLLite is also a good option
Upul
2010-05-31 07:44:27
SQLite doesn't support pretty much anything a real database needs (loops? triggers? concurrency???) It is OK to store configuration or data for single-threaded program. But it's not strictly speaking a database server - merely a file store with SQL-ish API
DVK
2010-05-31 08:33:47
A:
Guys, at this moment you're just some guys telling me... nothing. I asked for some proof. What I'm typically is in search for is proof that one or the other is faster on a smaller PHP web project.
What I mean by small is that there is around 10 tables in the database and they will contain around 2000 rows altogether perhaps. The database should rather be fast at selecting than inserting.
Dreshna
2010-05-31 08:52:02
How does one "prove" it is faster? You will always be able to create a specific case where you can find a counterexample - it depends too much in your configuration and application. Usually, pick the software you are best in - a well configured and tailored MySQL will beat any untuned DBMS.
Konerak
2010-05-31 08:56:02
Please don't post things like this as though it were an answer. Instead you should edit your question.
APC
2010-05-31 09:28:58
Garbage in, garbage out. Think about what influences the question. You are not even close to describing what you want.
Stephan Eggermont
2010-06-01 09:35:52
+1
A:
For a small project there should be no real difference. I'd suggest that you consider:
- speed of installation (Mysql is easier to install)
- features (Oracle has way more features in some areas)
- existing SQL knowledge for the DBMSes (SQL differs between Mysql and oracle)
etc.
Depending on your needs the answer may be oracle or mysql.
Patrick Cornelissen
2010-05-31 09:28:28