11/28/2023 0 Comments Postgres vs mysql performance 2021![]() ![]() ![]() Some of those are slightly better in some areas, and PostgreSQL is slightly better in some areas. NET." "PostgreSQL uses high memory compared to its counterparts when a highly demanding load is involved, especially one that makes many concurrent connections to the database." "The scalability is limited." "There are some products out there that have a slightly different method of implementation for the SQL language. Other languages like PHP and Java have good community support. I need to pay the provider if I need something more sophisticated features. NET has only one free provider in PostgreSQL. "We have to set up event API, which takes a lot of events from the user." "The price could be better." "The performance of PostgreSQL could improve." "I find it difficult to get connectors on the tool. We hope they will introduce the features soon." "MariaDB could be improved by adding more automation." There are a lot of features, which are available in Oracle, and which are not available in MariaDB. ![]() Many people don't even bother with that, and they just run one server." "Could have more integration with user platforms." "MariaDB can improve by adding more features. Mirroring the database in a live environment where any record written on the production server replicates instantly across the fiber on the other server wasn't easy. That kind of solution should be more baked into every single database today. Then there will be a bit of latency between both because you should have one in one city and another one in a different city. You need to have that replication server, but not in the same server farm. It would be better if they had a replication server. However, at this time it is working well for us." "The PL/SQL performance is slow if you have big batch jobs running overnight." "Replication could be better, and it's not so simple. "I would like to see a better user interface which would make the tool less complex." "An improvement would be scaling it up to the levels of Oracle, especially when it comes to resilience, so that we can do higher transactions for two databases or power our operation." "The solution can improve by having support for more integration. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |