Solved

Mysql vs Oracle

Posted on 2016-07-16
10
154 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 142

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 142

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 142

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

808 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