开发者

Which is faster for small web projects - MySQL or Oracle? [closed]

开发者 https://www.devze.com 2023-01-01 09:18 出处:网络
As it currently stands, this question is not a good fit for our Q&A format. We expe开发者_运维知识库ct answers to be supported by facts, references,or expertise, but this question will likely
As it currently stands, this question is not a good fit for our Q&A format. We expe开发者_运维知识库ct answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for guidance. Closed 12 years ago.

Which is generally faster for small web projects - MySQL or Oracle?

Please provide some proof (benchmarks or any other) of your opinion.


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.


For small web projects it doesn't matter. They are both fast enough.


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: When to choose Oracle over MySQL?


yes probably MySQL. For small projects I think SQLLite is also a good option


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.


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.

0

精彩评论

暂无评论...
验证码 换一张
取 消