Fastest Informix DBA Contest III 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 participate!

• Link to Article - How did they do it?
• Link to the Fastest 5 ONCONFIG Changes

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...

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

.