Re: Fastest Informix DBA Contest at the IIUG Conference - Webcast - How they did it?
Folks, We still have a few places on the Webcast with the winners of our Fastest Informix DBA contest from the IIUC Conference. The Webcast is: Thursday, May 21, 2009 Starting time: 4:00 pm, Eastern Daylight Time (New York, GMT-04:00) This Webcast is to find out how they took a 30 minute process and got it to run in under 5 minutes. The questions each one gets to answer are: 1. What did you see as the main performance problems to change? 1. What ONCONFIG changes did you make? 2. What SQL changes did you make? 3. How did you decided what to change? 4. If you could do it again, what else would you do? For pictures and more information on the contest: http://www.advancedatatools.com/Informix/index.html The Webcast is limited to 30 attendee's. To Register for the webcast please go to our webex site and look under upcoming events: https://advancedatatools.webex.com/ Regards - Lester Lester Knutsen wrote: > 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 ______________________________________________________________________