Major evaluation of databases such as MySQL ipvssql

Collation

With the development of the Internet and the increasingly active movement of Free Software, more and more people begin to apply various databases to their own network applications. As a result, a variety of database systems appear on the Internet stage, the two most commonly used databases here are MySQL
PostgreSQL and PostgreSQL have different applications and user groups on the Internet. Interestingly, it is like in the operating system field.
FreeBSD and Linux
There is also a lot of debate between the two databases, and these debates sometimes affect users' judgment to a large extent, at the same time, it will also make users feel uncomfortable when making choices. In order to make it easier for everyone to look at the problem with their own eyes, we specially sorted out some comparative information provided by various aspects here, for your reference. At the same time, the materials we collected include some information from other databases. To provide complete information as much as possible, we have also included the information. Here we mainly compare the features and performance, and there are other important factors, such as copyright and activity, which can be easily obtained from other resources behind us, I will not repeat it here.

Copyright Notice

The materials referenced in this document are owned by the original document and/or its Chinese translators. This document allows you to freely repost the materials for any non-commercial purposes. However, please refer to the copyright statement of each author for reprinting, if any conflict exists, contact the Corresponding author. The data and results in this article are carefully and strictly tested by the authors, but the authors do not perform any data or results.Any commitment and guaranteeAlsoDo not take any responsibility for any consequences caused by this article.

Version

V1.0.0rc1

Another rock

This is what Yan zixiong organized
A comparison written by Matthias warkus.

Here is a comment from a Russian hacker.

Wang maifangua

We have collected some evaluations and comparisons from various aspects.

This part of content is collected and organized by wangbin.

PostgreSQL Test

PostgreSQL
Your own comparative test is relatively simple, mainly based on the comparison of features, but it is interesting that there is no
MySQL, from the perspective of postgresql
It seems that it is not a complete database, probably because currently
MySQL still lacks some key database features.

Here isPostgreSQLMake a simple comparison by yourself.

MySQL Test

MySQL
A database test suite is provided, which is the most abundant and detailed data in the materials we collect. In addition
PostgreSQL also provides comparison data with many other databases. MySQL
The comparison is mainly based on the speed and performance, and has characteristics in comparison with all of its participating platforms. However, a lack
RDBMS-Interbase (Interbase said that the source code was open from 6.0, but I don't know whether it is GPL ).

The following content is MySQL
Information and test results obtained on the site:

You canMySQLFind the complete source code of the test program and some comparison data tables in the source code release version.

Table items marked with _ fast are tested in non-standard ansi SQL mode and with cleanup CILS. This is no longer a hundred percent SQL statement, but these data table items are still very useful.

Some table items are sent to us by anonymous mysql users, so the test data cannot be completely accurate. We recommend that you run this test program on the database you are interested in. If you want to share your test results with us, you can upload the files in the 'output' directory to 'www. tcx. SE/pub/MySQL/incoming, so that we can publish the test data in future test results.

The following chart shows all the participating databases in
Comparison in crash-me

Comparison of all participating databases provided in crash-me

The following figure shows the comparison between PostgreSQL and MySQL on Linux.

Comparison between PostgreSQL and MySQL

Same as MySQLRelative Comparison,Absolute comparison

Comparison between Access 2000 and MySQL on the Win98 Platform

Comparison between Access 2000 and MySQL

Same as MySQLRelative Comparison,Absolute comparison

Comparison between adabas and MySQL on Linux

Comparison data table of adabas and MySQL

Same as MySQLRelative Comparison,Absolute comparison

The following table compares DB2, Informix, MS-SQL, MySQL, solid and Sybase on the NT 4.0 platform.

Comparison between DB2, Informix, MS-SQL, MySQL, solid and Sybase on the NT 4.0 Platform

Same as MySQLRelative Comparison,Absolute comparison

The following are empress, PostgreSQL, and MySQL on Linux.
Comparison table with MySQL

Comparison data tables of Empress, PostgreSQL, MySQL, and solidsybase on the NT 4.0 Platform

Same as MySQLRelative Comparison,Absolute comparison

The following table compares MySQL, PostgreSQL, and solid on Linux.

Comparison between MySQL, PostgreSQL, and solid on Linux

Same as MySQLRelative Comparison,Absolute comparison

Comparison between MySQL and Oracle 8.0.3 on the NT Platform

Note: In this test, Oracle is accessed through ODBC! Many users use their oracle APIs to get faster speeds!

Comparison between MySQL and Oracle 7.0

Same as MySQLRelative Comparison,Absolute comparison

Comparison of table-based msql and MySQL is restricted to a few comparisons due to msql limitations.

Comparison data table of msql and MySQL

Same as MySQLRelative Comparison,Absolute comparison

The following table shows how MySQL works on different platforms.

Note the differences between CPU clock speed and available memory between different platforms

Comparison of numbers on different platforms

Same as MySQLRelative Comparison,Absolute comparison

Appendix:

Tcx statement information:

The information is
Tcx provides, so users can get the actual situation of different databases (rather than the information provided by the seller ). We hope that the above information will make it easy for you to find such a database server that has the functions you need and you can safely use.

We will continue to make
MySQLThe test helps you understand the running speed of the database during different typical tasks.

Tcx will continue developmentCrash-meShows the real defects and performance of the database server.

Other resources

In www.linux.com and www.linuxcare.com
There are also some comparisons of the voting nature. These are mainly users' personal preferences and opinions. There are no clear test standards and methods, but they are of reference value to everyone, we will list the links here. Please visit these links to view the voting results.

Shift axe

From the above evaluations, we can see that the common characteristics of these two databases are distinctive, with their respective highlights and weaknesses, so can we come to the conclusion that the advantages and disadvantages are better than the disadvantages, and decide what does not support what? We think this is not the case, because the development of the two databases is very active, and many current shortcomings may soon be compensated, for example:
In the MySQL todo list, transaction support is clearly placed in the most important position; and
Latest PostgreSQL version 7.0
The speed and stability are greatly improved, and at 7.1
We will greatly enhance the existing large object interfaces. These indicate that both of them are making progress and are constantly evolving. What we really make is ourselves as application developers, through reasonable analysis, we can develop strengths and circumvent weaknesses, correctly select the appropriate database, and meet the application needs to the maximum extent. Do not forget that the task of working as a computer practitioner is to use our hours and experience to provide services to non-professional personnel. Finally, we will continue to compare the information and update our information, hoping to provide you with more detailed materials.