Fastest Informix DBA Contest III – April 2010

Published on April 29, 2010 by Lester Knutsen

Congratulations to the winners!

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 participated!

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 below in the order of contestants with the most transactions per minute.

The Fastest Informix DBA and Grand Prize Winner: Tatiana Saltykova

Fastest IBM Developer (IBM employee): Spokey Wheeler

Fastest DBA on Monday (First day of the contest): Tom Girsch

Fastest International DBA (Non USA resident): Denis Zhuravlev

Fastest Mid-Aged DBA (30-50): Andrew Ford

Fastest Youngest DBA (under 30): Pam Siebert

Fastest Old-timer (longest experience with Informix): Wenching Chiang

Fastest Domestic DBA (USA resident): Eric Rowell

Links on how they did it: