Re: Fastest Informix DBA Contest at the IIUG Conference
David, Sorry you are not going to be there to try it out. > Which of the following are allow? > > SQL Layer > 1. rewriting the SQL Allowed and encouraged as long as the results are the same. > > Server Layer > 1. changing server parameters Allowed and encouraged . > 2 changing the amount of memory used by the server Allowed and encouraged. > 3 changing the disk layout (dropping/recreating dbspaces + tables/ > indexes) Allowed and encouraged. > 4 changing Informix fragmentation strategies Allowed and encouraged. > > 'Disk Manager' kayer > 1 For cooked devices ia changing the filesystem parameters allowed? > fstune? It will be using cooked files and I had not thought about this.... I need to confer with the judges. > 2 Is this Veritas (or another disk manger e.g. Disksuite) and can that > be tuned as well? Sorry, I am not shipping my disk arrays to the conference. Just one machine with cooked files. > Storage Layer > 1 Is this on a SAN and can the SAN config be tuned? > 2 What about changing the disk layout of LUNs across spindles? See above, but this would definitely be interesting, > > Pity I am not going... I am sorry too - lester david@smooth1.co.uk wrote: > On 10 Apr, 20:32, Lester Knutsen <les...@advancedatatools.com> wrote: >> Fastest Informix DBA Contest >> >> Advanced DataTools is sponsoring a contest at the International Informix User Conference in Kansas City, April 26-29, 2009, 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 soon! >> -- >> ______________________________________________________________________ >> Lester Knutsen les...@advancedatatools.com >> Advanced DataTools Corporation Voice: 703-256-0267 x102 >> Visit our Web page:http://www.advancedatatools.com >> ______________________________________________________________________ > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > > > -- ______________________________________________________________________ Lester Knutsen lester@advancedatatools.com Advanced DataTools Corporation Voice: 703-256-0267 x102 Visit our Web page: http://www.advancedatatools.com ______________________________________________________________________