Advanced DataTools is pleased to announce the results of our third Fastest Informix DBA contest held at the 2010 IIUG Informix Conference, April 25-28 in Kansas City, MO. Thank you to everyone who participate!
This time the contest was an OLTP benchmark using the BenchmarkSQL Java program to generate 100 sessions doing inserts, updates, and deletes against a database. BenchmarkSQL is an easy to use JDBC benchmark that closely resembles the TPC-C standard for OLTP. Databases supported include EnterpriseDB, PostgreSQL, Oracle, Sybase, SQLSvr, MySQL, HsqlDB, Derby/JavaDB & FireBird. See Source Forge at http://sourceforge.net/projects/benchmarksql/ for more information. The Java code was converted to run with Informix by AGS, the folks that created ServerStudio.
The challenge was to get the most transactions per minute during a 10-minute benchmark run. The winners are listed in the order of contestants with the most transactions per minute.
Download the benchmark and try it yourself...