I'm pleased to announce the release of SQL Bench, the benchmark
test suite the comes standard with MySQL, now as a separate
project targeted for testing any database. I have pulled it out
as a separate project so I can modify and improve it faster. With
this release, I have successfully used it for testing both
Drizzle and MySQL. Other RDBMSs, I have yet to test.
Modifications
I modified the connection test, which part of it is to connect,
run a single query for one row, disconnect, to iterate only
20,000 times vs. 100,000 times. The reason for this is to allow
this test to reasonably test databases that use TCP sockets. When
I added Drizzle support to SQL Bench, upon running the connect
test it would fail inexplicably. After some serious testing, it
was realized that since Drizzle uses TCP sockets, even when
connecting to localhost, that the connect test would fail because
of the result of sockets being kept around in …
[Read more]