MySQL X PostGreSQL
49According to the Academic Research in Monographs:
To be held on equal terms, what the other party, is often complicated because of the results in different implementations that all of these managers.
In addition, too complex to develop a good base, taking into account all possible improvements in income, which can realize each of these leaders.
This is logical, therefore you have evidence that apply to the manager, and that it makes no sense to hold each other.
With the emphasis of this work were identified as the best PostgreSQL. Positive characteristics that the leader of the second most common views are:
It has great accessibility. It can adapt to the number of processors and amount of data that the system is so great that makes it able to maintain a greater number of simultaneous requests in an appropriate manner (in some indicators, says has become a triple burden to bear, which supports MySQL).
-- Military use rollback 's, subconsultas and transactions, to make it work much more efficient, and offers solutions in areas where MySQL could not.
She has an opportunity to prove referential integrity, as well as store procedure in the database, comparing it with the leaders of databases at a high level, as Oracle.4.3.
Nevertheless, compared with MySQL, the main shortcomings, which can be found in PostGre manager are:
-- Consumes large amount of resources.
-- It has 8K limit on the line, although it could rise to 32, with significant loss of income.
-- This is from 2 to 3 times slow MySQL
According bibliographically raised to this book, it becomes clear that the overwhelming majority of the population uses the Internet is a manager, and we see favorable reviews will not lead to absolute complicated.
Without a doubt, place, the best of MySQL is its speed at the time of the transaction, making it one of the managers who offer high profitability. Its low power consumption makes it suitable for running on a machine with limited resources without any problems.
The usefulness of this administration invejáveis manager for many of the existing commercial managers, because of its great ease of configuration and installation. She has a very low probability of bribery of data, even in cases where the error is not in itself produce manager, but a system where it is.
The number of applications Apache-PHP-MySQL is one of the most used Internet services to the court and prosecutors applications
Because of this wider acceptance on the Internet, many of the shortcomings suggestions below, were taken from the comparative data with other banks:
-- Lack of support and operations in subconsultas rollback.
What can not do referential integrity, makes this manager poor solution for many applications, especially for those developers with other leaders of which are such a possibility.
This is not really for use with large databases to which access is permanently because they did not exercise good accessibility.
PrintShare it! — Rate it: up down flag this hub








