Don't forget to register for the Fastest Informix DBA webcast tomorrow. Lester, Art and I will be talking about how the winners achieved our results at IIUG 2012. In my case, I'm going to go with lots and lots of luck and a power surge that gave Lester's Mac Mini Server super computing strength at the precise moment I started my benchmark run.
Here is the info:
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.
Webcast: Fastest Informix DBA Contest - How did they do it?
Date: Tuesday, June 19th, 2012 at 2:00pm EST
Register: http://www.iiug.org/url/adt-fastest-dba.html
Info: http://www.advancedatatools.com/Informix/index.html