TPC-C / TPC-H benchmark utility

Good afternoon, Does anyone know of an open-source or low-cost benchmark tool that will run Informix SQL tests and return timing/performance results with similar loads in TPC-C or TPC-H standards. Of if you know of a good Informix Stress-Test utility that produces results in completion time. Stort tack på förhand Jonathan B. Smaby Pomona College Administrative Information Systems Office phone: (909) 621-8506 email: jonathan.smaby@pomona.edu --- "Just because nobody complains doesn't mean all parachutes are perfect." - Benny Hill (1924 - 1992) ------------------------------------------------------------- This message has been scanned by Postini anti-virus software.

Jonathan, Please copy me if you got a reply to this. I talk alot about benchmarking in the IIUG Insider articles I wrote in the January and February Insiders. In the February one I give you the link to the TPC web site which I believe may have what you want. Please let me know, I still learning about all of this. http://www.iiug.org/Insider/insider_feb09.php#8.1 Thanks! Kate Tomchik [ kate@iiug.org ] www.iiug.org International Informix Users Group Board of Directors A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratliffe ---------- Original Message ----------- From: "Jonathan Smaby" <Jonathan.Smaby@pomona.edu> To: ids@iiug.org Sent: Tue, 24 Mar 2009 16:36:31 -0400 (EDT) Subject: TPC-C / TPC-H benchmark utility [15323] > Good afternoon, > > Does anyone know of an open-source or low-cost benchmark tool that > will run Informix SQL tests and return timing/performance results > with similar loads in TPC-C or TPC-H standards. Of if you know of a > good Informix Stress-Test utility that produces results in > completion time. > > Stort tack på förhand > > Jonathan B. Smaby > Pomona College > Administrative Information Systems Office > phone: (909) 621-8506 > email: jonathan.smaby@pomona.edu > --- > "Just because nobody complains doesn't mean all parachutes are > perfect." - Benny Hill (1924 - 1992) > > ------------------------------------------------------------- > This message has been scanned by Postini anti-virus software. > > ***************************************************************************** ** Forum Note: Use "Reply" to post a response in the discussion forum. ------- End of Original Message -------

Jonathan Smaby wrote: > Good afternoon, > > Does anyone know of an open-source or low-cost benchmark tool that will run > Informix SQL tests and return timing/performance results with similar loads in > TPC-C or TPC-H standards. Of if you know of a good Informix Stress-Test > utility that produces results in completion time. It's not difficult to code the TPC-H, IIRC they provide a reference C program that you can amend for ESQL/C. -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean.