How would MySQL compare with SQL Server or Oracle databases?
-
Besides the fact that it is free, is a start-up going to miss having several features that proprietary databases like SQL server or Oracle have in them?
-
Answer:
I use SQL server on half my projects and mySQL on half my projects. If you have the money I would suggest SQL server as it has a few extra features you may be looking for and a nicer (in my opinion) interface to the db for setting up dbs/tables, creating jobs, backups/restores, and data transfer. A major drawback for mySQL up until recently was the inability to create views, stored procedures, nested queries and have XML features. I believe the first two have been addressed in the new version (I am still using ver 4 on most of my projects). SQL server has pretty good built in XML commands to return data in XML format. It also has great data transfomation packages you can create if your application needs to regularly import or export large amounts of data from various sources. If you don't need some of these 'extra' features I would say mySQL is a good choice. I have never ran into any performance or reliability issues with it, is just doesn't have as many featues as SQL server (which may be OK if you don't need them). The new version of mySQL now comes with a great admin and query program to manage the db in a more visual way which is a huge plus over previous versions. Also, remember you aren't tied to Windows for your hosting environment with mySQL which may be cost issue if you grow in the future. I would steer clear of Oracle. It is very expensive and hard to learn/setup. I have migrated several clients from that to SQL and mySQL since they didn't have the resources to properly manage the db. I can't think of anything that Oracle offers that you can't accomplish with SQL server.
xdwcpsd at Yahoo! Answers Visit the source
Other answers
all I want to tell you is that Google uses MySQL for their large AdWords Database. Now make the choice for yourself.
iammisc
MySQL, like much open source code, comes with free advice. I find it much easier to find advice on message boards about MySQL then in Microsoft Developers Area.
LorettoBoy
for a start up, mysql will do just fine. personally, i feel that oracle is over-rated, and i've never touched SQL server. just hire someone who knows what they are doing. a lot goes into database design :)
duct_tape_is_good
Related Q & A:
- How can I optimize this dynamic SQL query in oracle with PL/SQL?Best solution by docs.oracle.com
- How to do GROUP_CONCAT in SQL Server?Best solution by Stack Overflow
- How to import XML into SQL Server database?Best solution by Stack Overflow
- How do I connect to SQL Server using C#?Best solution by Stack Overflow
- How to replace Cursor in SQL Server?Best solution by stackoverflow.com
Just Added Q & A:
- How many active mobile subscribers are there in China?Best solution by Quora
- How to find the right vacation?Best solution by bookit.com
- How To Make Your Own Primer?Best solution by thekrazycouponlady.com
- How do you get the domain & range?Best solution by ChaCha
- How do you open pop up blockers?Best solution by Yahoo! Answers
For every problem there is a solution! Proved by Solucija.
-
Got an issue and looking for advice?
-
Ask Solucija to search every corner of the Web for help.
-
Get workable solutions and helpful tips in a moment.
Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.