By Leon Katsnelson
By Susan Visser
By Bernie Spang
By the DB2 Guys
By Fred Ho
By Louis T. Cherian
By Shweta Shandilya
By Lawrence Weber
By Serge Rielau
By Dwaine Snow
We just completed the fifth Fastest Informix DBA Contest at this year’s IIUG Informix User Conference, sponsored by my company, Advanced DataTools Corporation. It was a great event and everyone had fun participating. Congratulations to Andrew Ford, the Grand Prize Winner of the new Apple iPad and Fastest Overall Informix DBA! Andrew’s results were almost three times faster than the next closest contestant’s results.
This contest has been one of the more fun events at the last few Informix User Conferences. This year, the contest was run on an Apple Mac Mini Server using Informix Enterprise 11.70.FC4. The server is very small and cheap—1.4 inches by 7.7 inches square—and costs under $1,400. The CPU is an Intel Core i7 with four cores, 8 GB of RAM, and two disk drives (one for the application and one for the database). It is amazing to see 1,000 user sessions running on this little box and to achieve the level of throughput that Andrew accomplished.
The goal of the contest is to see who can optimize an Informix database server running 1,000 OLTP users in under one hour and generate the most transactions per minute. Andrew generated over 57,000 transactions per minute.
We used the open source BenchmarkSQL Java program to generate the transactions for this contest. BenchmarkSQL is a JDBC benchmark that closely resembles the TPC-C standard for OLTP. It generates 1,000 sessions doing inserts, updates, and deletes against the Informix database server. I will describe the performance tuning measures that Andrew and the other constants used in a future article.
This was one of the best IIUG Informix User Conferences that we have ever had. The IIUG and conference planning committee did an awesome job pulling it all together. We had more Informix users in attendance than ever before, excellent information-packed sessions, and great food and parties. I look forward to more of these in the future. If you are an Informix user and were not able to attend, you really need to consider attending next year.
DB2 TechTalk: Deep Dive on BLU Acceleration in DB2 10.5, Super Analytics Super Easy
Thursday, May 30: 12:30 – 2:00 PM ET
Big Data Seminar 2013, Featuring Krish Krishnan
June 14 in New York City
marcus evans Pharma Data Analytics Conference
July 10-11 in Philadelphia
IBM Smarter Content Summit 2013
Big Data at the Speed of Business
Broadcast event replay now available
Information on Demand 2013: Early Bird Registration Now Open
November 3-7 in Las Vegas