next up previous
Next: Problems encountered during performace Up: Implementation Previous: Safe launching and possible

Performance testing

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.


next up previous
Next: Problems encountered during performace Up: Implementation Previous: Safe launching and possible
Wiktor Kolodziej 2006-01-12