Comparing DB technologies [closed]

manpreet Best Answer 2 years ago

I'm going to start a simple SaaS application and am considering which DB to go with(MSSQL, MySql, Oracle).

Can someone who experience it(actual use)point the pros and cons(performence,costs,easy to develop,easy to maintain) of each technology and recommend his favorite?

manpreet 2 years ago

This can't be answered in the context of which you've asked it. There are a couple things that can make your decision easy (like cost) and I've included some information below that I hope you find useful.

1.) Budget

• If you don't have one or it's small, then MySQL is certainly your best option. If you're storing a very small amount of information, you may be able to use a fairly inexpensive Oracle or SQL Server license, but as things get larger both of those technologies get expensive quickly.

2.) Data Storage

• This kinda goes along with the other, but as the size of your data increases you will likely want to start partitioning data. This is free in MySQL, but an extremely expensive optionwith Oracle. (I'm uncertain with SQL Server) Oracle, charges per processor (and uses a core factor based on the architecture for processors over 2 cores) for partitioning and the list price of that is ~9k per. If you want support it's ~20% of that per year. What makes this worse is that you can only get partitioning in Oracle if you have Enterprise licenses which are quite expensive in themselves. As you can see...it takes some $$$ to run a partitioned Oracle database.

3.) Management

• This will depend on prior experience. I have the least experience on SQL Server, but find it's management tools easy to use. Oracle has good tools but it's complexity can lend to a steeper learning curve.

Hope this information helps you in your decision