Performance Testing Various Databases

I am currently testing a few different relational database management systems. (MySQL, PostgreSQL, Oracle and Firebird SQL) using a Java application to do so.

I was debating what tests I should run to distinguish the performances of each.

The obvious ones would be insert, select, delete and drop.

I would love to hear your opinions and to make this apply to the question answer format I shall ask for the 5 most appropriate tests to indicate performace differences. In an ideal world I would like to mimic real wo开发者_如何学Crd use.

Thanks to all who answer.

I think that any of them would probably be fine. However, your configuration of the different databases for what you are trying to do would be different based on your application.

Suggested place to start: look for apps similar to yours. See what they are using, if you can. Then start testing the different databases with similar configurations and see what works for you.

Personally I've used Oracle, MySql, and Postgres over the last 11 years and they've all worked well. It's really all in your configuration, which is where a good DBA comes in handy.

Here are the results of a fairly extensive benchmarks of JPA providers and RDBMS's. You can either use the data they provide, or you can download their code and run it yourself.

Test concurrency. In other words, what happens under various locking scenarios? Ideally you would like to test under as close to real world conditions as possible, with multiple users using the system as it was meant to be used. See my answer to this SO question.