Derby (Cloudscape) & Mysql

I’ve been looking into Derby, the java ligthweight database that IBM gave to the apache foundation. I wrote a litle test program to do some random insert, select on an indexed field, on an unindexed field and some randum updates. I created a table with a integer field and a varchar(50) field. I generated 10000 random int and the same amount random strings and inserted them.
By a stupid mistake my home partition got lost and I couldn’t recover it. I going to try to rewrite the benchmark program. But the big picture was that the insert were more then 15 times faster on mysql. The selects and updates were suprisingly about 3 times faster on derby then on mysql.
I’m going to write a new application and try to get sqlite in the results. I want to run the tests also on my desktop machine. They have almost the same processor and memory but the hd is much faster.
I’ll get back on that, because it’s quite interesting.