Okay, here are the pros and cons for Oracle:
Pros:
1) Stable, enterprise supported platform.
2) Able to handle large amounts of data transfers.
3) Cross-platform compatible.
4) Ease of use w/ 3rd party software (i.e. Quest Software's TOAD) for data manuplation.
Cons:
1) Needs alot of RAM and Hard Drive space to run correctly. SCSI drives and ECC ram usually required due to Oracle specs and tuning issues.
2) Data dump cannot be done in text format. Strictly binary only.
3) Database must be tuned on a regular basis to run correctly, especially for multi-threads.
4) Express version does not have all features of basic Oracle release. Express version limited in number of processors, ram cap, database size cap, etc. Total cost of investment can exceed thousand dollar mark very easily.
MySQL vs Oracle
Some things unique to MySQL that Oracle does not offer include:
- storage engines, choices like InnoDB, MyISAM & Cluster
- fast connections
- easy replication
- overall ease of use
- lower total cost of investment
For more information, I recommend reading the following article based on database comparisons...
-- Silver
|