Re: Fastest Informix DBA Contest at the IIUG Conference
Folks, The winners are: Grand Prize - Fastest User DBA - Andrew Ford Runner Up and Fastest Mid-Aged DBA (30-50) and Domestic DBA - Tom Girsch Fastest IBM Developer - Spokey Wheeler (best overall time) Fastest Old-timer (longest experience with Informix) - David Link Fastest Senior DBA (over 50) - John Fahey Fastest Professional Consultant DBA - Warren Donovan Fastest Youngest, Newest, and Fastest International DBA - Jean-Michel Ramseyer Congratulations to everyone who participated, this was a blast and I think everyone had fun and did a great job. They all took a poorly tuned onconfig file and sql script that took over 30 minutes to run and had in running in 1-4 minutes. We are planning to do a podcast or webcast with the winners to find out how they did it. And we are looking at ways to do this again so stay tuned! Regards - Lester Lester Knutsen wrote: > Folks, > > There are only a few days left before the international Informix User Conference in Kansas City, April 26-29. http://www.iiug.org/conf/2009/iiug/ > > Advanced DataTools is sponsoring a contest at the Informix User Conference, to find and honor the fastest Informix DBAs. The challenge is to take a basic Informix database server and a SQL script that takes about 30 minutes to run, and see who can get it to run the fastest. Can you take a new Informix install and, without any prior knowledge, optimize it in 30 minutes? > > There will be 10 winners in the following categories (Grand Prize will be an iPod Touch): > > CATEGORIES: > Grand Prize - Fastest User DBA. To qualify for this prize, the user must be 1) a paid attendee at the conference (or conference speaker or volunteer, at discretion of the judges), 2) not a consultant, 3) not an IBM employee, and 4) employed by a company using Informix internally. > > Honorary Prize - Fastest Professional Consultant DBA > Honorary Prize - Fastest IBM Developer (IBM employee) > Honorary Prize - Fastest Senior DBA (over 50) > Honorary Prize - Fastest Mid-Aged DBA (30-50) > Honorary Prize - Fastest Youngest DBA (under 30) > Honorary Prize - Fastest Newest DBA (shortest experience with Informix) > Honorary Prize - Fastest Old-timer (longest experience with Informix) > Honorary Prize - Fastest International DBA (Non USA resident) > Honorary Prize - Fastest Domestic DBA (USA resident) > > The challenge will be to complete the following tasks in under 30 minutes: > - Tune and optimize the Onconfig file > - Tune the optimize dbspace/table layout > - Tune the optimize SQL script > - Run the script > > The rules: > - Must be in attendance at the IIUG Informix Conference > - The row and data counts at the end of the SQL process must be correct. > - Must make an appointment at the Advanced DataTools booth to enter in the contest. > - All work must be done at the booth; no copies (usb, email) of the scripts will be allowed. > - Each participant will have 30 minutes to review and optimize the server and SQL code on a machine provided. > - Each participant will be monitored by an Advanced DataTools Consultant. > - Each participant's configuration will be saved and the results must be reproducible by the judges. > > Judges: > - Lester Knutsen > - Art Kagel > - Carlton Doe > (The judges' role will be to review the results, arbitrate any disagreement(s), and have final say.) > > More information will be available on our web site - http://www.advancedatatools.com/Informix/index.html > -- ______________________________________________________________________ Lester Knutsen lester@advancedatatools.com Advanced DataTools Corporation Voice: 703-256-0267 x102 Visit our Web page: http://www.advancedatatools.com ______________________________________________________________________