Advanced DataTools: Fastest Informix DBA Contest 2012

Posted in 2012

Topics: Connectivity: ODBC / JDBC / .NET, Server Administration, Java & JDBC Development

Lester Knutsen — Sun, 29 Apr 2012 11:07:34 -0700 — source: Usenet: comp.databases.informix

New Fastest Informix DBA Contest 2012 1,000 OLTP users benchmark run on a Apple Mac Mini Server Andrew Ford is the Grand Prize Winner of a new iPad Advanced DataTools is pleased to announce our latest Fastest Informix DBA Contest that was held at the 2012 IIUG Informix Conference, April 22-25, 2012 in San Diego, California. Congratulations to Andrew Ford, 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 8 GB 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 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. 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. For more info see - http://www.advancedatatools.com/Informix/index.html Regards - Lester -- ______________________________________________________________________ Lester Knutsen lester@advancedatatools.com Advanced DataTools Corporation Voice: 703-256-0267 x102 Visit our Web page: http://www.advancedatatools.com ______________________________________________________________________

↪ replying to Lester Knutsen

Malc P — Mon, 30 Apr 2012 05:07:30 -0700 (PDT) — source: Usenet: comp.databases.informix

On Sunday, 29 April 2012 19:07:34 UTC+1, Lester Knutsen wrote: > New Fastest Informix DBA Contest 2012 > > 1,000 OLTP users benchmark run on a Apple Mac Mini Server > > Andrew Ford is the Grand Prize Winner of a new iPad > > Advanced DataTools is pleased to announce our latest Fastest Informix DBA Contest that was held at the 2012 IIUG Informix Conference, April 22-25, 2012 in San Diego, California. > > Congratulations to Andrew Ford, Seconded! But ... where was the Clown? Conspicuous by his absence, this year?