Solved

Mysql vs Oracle

Posted on 2016-07-16
10
171 Views
Last Modified: 2016-08-04
Hello Experts,
Our customer needs to distribute a small app to several distant locations....
Now this app will have a database...
1) Which is the best database to distribute many times (like little less than a hundred )
2) Is it ok to consider Oracle and MySQL as the top databases in the world for medium and small apps for distribution ?
3) which database would you suggest for easy remote instalation and implementation as well as maintenace?

regards,
0
Comment
Question by:rguillermo
  • 3
  • 3
  • 2
  • +2
10 Comments
 
LVL 1

Expert Comment

by:klamerus
ID: 41714914
You can't just distribute oracle.  It's a licensed DB.
0
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 250 total points
ID: 41715033
0
 
LVL 1

Expert Comment

by:klamerus
ID: 41715776
Ah thanks.  Didn't realize that existed.

What OS is this for?  That's relevant to the discussion.
0
Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 41715793
Any os oracle supports
0
 
LVL 1

Expert Comment

by:klamerus
ID: 41715847
Yes, the question what was cost effective and if the target is Windows then there's probably a value in considering SQL Server.
0
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 41715862
Indeed, as sql server express version also exists.
Like oracle and mysql, the "free" versions come with limitations that need to be clearly studied before choosing
0
 

Author Comment

by:rguillermo
ID: 41715994
Hi thank you for your answers,
I am seeing the main limitations for Oracle XE are

11GB of data and 1 GB Ram.... no hard limit for user connections..
Is there any other important limitation?
Thank you
0
 
LVL 76

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 250 total points
ID: 41716052
>>Is there any other important limitation?

CPU.

...
Oracle Database XE can be installed on any size host machine with any number of CPUs (one database per machine), but XE will store up to 11GB of user data, use up to 1GB of memory, and use one CPU on the host machine.
...

http://www.oracle.com/technetwork/database/database-technologies/express-edition/overview/index.html
0
 
LVL 13

Expert Comment

by:Alexander Eßer [Alex140181]
ID: 41716366
Any os oracle supports
BUT not any architecture ;-) E.g. ARM based systems like Raspberry devices
0
 

Author Closing Comment

by:rguillermo
ID: 41743676
Thanks to all Experts very much !!!
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Creating and Managing Databases with phpMyAdmin in cPanel.
Never store passwords in plain text or just their hash: it seems a no-brainier, but there are still plenty of people doing that. I present the why and how on this subject, offering my own real life solution that you can implement right away, bringin…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Via a live example, show how to take different types of Oracle backups using RMAN.

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question