Testing the performance of various databases

Question

I am currently testing several different relational database management systems. (MySQL, PostgreSQL, Oracle, and Firebird SQL) using a Java application for this.

I discussed which tests I should perform to distinguish between the characteristics of each of them.

The obvious ones are insert , select , delete and drop .

I would like to hear your opinion and do it in relation to the format of the answer to the question. I will ask for the 5 most suitable tests to indicate differences in performance. In an ideal world, I would like to imitate the use of a real word.

Thanks to everyone who answers.

Answer 1

I think any of them will probably be okay. However, your configuration of the various databases for what you are trying to do will vary depending on your application.

Suggested place to start: find apps similar to yours. See what they use if you can. Then start testing various databases with similar configurations and see what works for you.

Personally, I have used Oracle, MySql, and Postgres for the past 11 years, and they all worked well. This is really everything in your configuration where a good DBA comes in handy.

Answer 2

Below are the results of fairly extensive tests by JPA and RDBMS vendors. You can use the data that they provide, or download your code and run it yourself.

Answer 3

Concurrency test. In other words, what happens with different blocking scenarios? Ideally, you would like to test as close to the real world conditions as possible when several users used the system because it was to be used. See my answer to this SO question .