Fastest DBA: Webcast from Advanced Data Tools
Title: Fastest Informix DBA Contest - How did they do it?
Date: Tuesday, June the 19th, 2012
Time: 02:00 PM (EST), 20:00h Germany
Presented By: Lester Knutsen / Art Kagel (Advanced Data Tools)
Registration: Fastest Informix DBA Contest - How did they do it?
Please join Andrew Ford, Lester Knutsen, and Art Kagel at 2:00pm EST on Tuesday, June 19th, for a Webcast to share with other Informix users how the winners of the 2012 Fastest Informix DBA Contest achieved their results. Learn about the tips and tricks the Fastest Informix DBAs used to achieve their remarkable performance.
Advanced DataTools held our latest Fastest Informix DBA Contest, at the 2012 IIUG Informix Conference, April 22-25, 2012 in San Diego, California. Andrew Ford, was the Grand Prize Winner of the new Apple iPad and the Fastest Overall Informix DBA.
Andrew's results were almost three times faster than the next closest contestant's results. This year the contest was run on an Apple Mac Mini Server, using Informix Enterprise 11.70.FC4. The server is very small and inexpensive, 1.4 inches by 7.7 inches square. The CPU is an Intel Core i7 with 4 cores, and includes 8GB of RAM, and it has 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 was to see who could 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. The BenchmarkSQL is a JDBC benchmark that closely resembles the TPC-C standard for OLTP. It is a Java program that generates 1,000 sessions doing inserts, updates, and deletes against the Informix database server.