How to test Performance of various databases?

Ask a question+
0

Hi everyone. I am working on MySQL, PostgreSQL, Oracle, and Firebird SQL relational database management systems. And for that, I am using a Java application. I am looking for a test which will distinguish the performances of each one. Any suggestions?

Alvard 630
add comment

1 Answer

0

You should set up a baseline of tests you want to perform. You should take into account that writes is going to take more resources than anything that reads. First, you should use some insert and update queries, then some selects. These can be run in batches, probably with looping. And remember, once you establish a baseline is to run the same set of queries on each DB. Your configurations on each DB should be equivalent to yield a valid result.

Sargsyan 580
add comment

Your Answer