There are two approaches to performance testing, either to use dedicated software
or to write own tests.
We have decided to measure the time the console program for dumping mysql databases (mysqldump) consumes and compare it to the dump of the same database set, but created by jdbdump.
Here are the results of mysqldump and our Dump comparison:
SIZE | MYSQLDUMP TIME | JDBDUMP DUMP TIME |
4.3MB | 1,53 s | 6.20 s |
7.2 MB | 2.5 s | 12.6 s |
10.3 MB | 4.05 s | 21.9 |
15.2 MB | 6.7 s | 51.75 s |
21.7 MB | 8.5 s | 90.3 s |
As we had expected mysqldump turned out to be faster. That is caused by many factors, for example that it is a natively compiled program and Jdbdump runs on a virtual machine, it handles MySQL databases specifically and Jdbdump tries to be universal, and Jdbdump uses JDBC calls which add another layer of complexity.