Differences and options between MySQL and Oracle

First of all, there are many types of database performance.

1: Speed performance.

2: Concurrency performance.

3: Transaction performance.

In terms of speed performance, first you need to determine your test environment.

For example, if your software is likely to be used by a group of customers using 586 computers, then MySQL must be more efficient than OracleThat's why, MySQL doesn't do as much work on transaction and security policies as Oracle. If the software does not require high requirements in this regard, then it is possible to use MySQL, so that the configuration of the machine can be relatively low, but the performance will be superior.

In order to make Oracle fully show its performance, you should choose some powerful minicomputers or servers as the test environment (although such an environment may be wasteful for MySQL, but this can ensure that both databases can fully play their own characteristics).

Second, test the access speed, and you can see the effect by writing a large number of writes to the database. The so-called mass write should try to use a stored procedure to read a 10M data file at a time, and then write and record the time (as well as the CPU, memory, etc. footprint). Then, perform a Cartesian product query (full join) for at least two tables with more than 100,000 data tables to check the query time.

The key is whether your business needs transaction processing, if so, only oracle, whether your data accuracy is very important, security control is very important, if so, only oracle.

1、**。** is the most significant difference between the two databases. Oracle has something called Oracle Express Edition, and this version is completely free.

Unfortunately, the version has too many limitations on these features. If you continue to buy the full-featured Standard or Enterprise edition, it will cost you tens of thousands of dollars. MySQL, on the other hand, is an open-source database that is completely free.

The most famous Facebook social ** runs on MySQL.

2. Safety. While MySQL uses three parameters to authenticate users, i.e., username, password, and location, Oracle uses a number of security features such as username, password, profile, local authentication, external authentication, advanced security enhancements, and more.

3. The name of the object.

While some schema object names are case-insensitive in both Oracle and MySQL, such as columns, stored procedures, indexes, etc., in some cases, the case sensitivity is different between the two databases; Oracle is case-insensitive to all object names, however, unlike Oracle, some MySQL object names, such as databases and tables, are case-sensitive (depending on the underlying operating system).

4. Character data type.

There are some differences in the types of characters supported in the two databases. MySQL provides char and varchar for character types, with a maximum length of 65,535 bytes (char can be up to 255 bytes and varchar is bytes). On the other hand, Oracle supports four character types, namely char, nchar, varchar2, and nvarchar2; All four character types need to be at least 1 byte long; char and nchar can be up to 2000 bytes, and nvarchar2 and varchar2 have a maximum limit of 4000 bytes.

Extensions may be made in the latest version.

Oracle is charged, and MySQL is open source. It's all databases. Functionally, Oracle is a commercial large-scale database, and you can get better services after paying.

MySQL is free of charge, but you still need to pay for support. Functionally, the benevolent see the people, and the wise see the wise. Personally, I think Oracle is suitable for secure, large-scale requirements.

If you have a medium scale and the functional requirements are not very complex, you can choose MySQL

MySQL is a small and medium-sized database, which occupies relatively few resources after installation, and has a free version and open source**.

Oracle is a large database.

Oracle is for the enterprise.

MySQL is for small companies.