Josef:
The Informix port of the open source SQLBenchmark software used by Advanced DataTools Corp. for the Fastest DBA Contests was done by a third party who doesn't want it published. In addition to Eric's benchmark package, you might also want to look at iReplay from Exact-Solutions (Home | Exact Solutions, Inc). You use it to take a snapshot of actual production activity for a period of time (an hour, a day, etc.) which can then be replayed against a restored copy of the database's state at the start of the snapshot to get a performance baseline. Then you can tune that test engine, upgrade the version, migrate it to a new platform, and test again to see how those changes affect performance! Not inexpensive, but a far better indication of actual performance effects of different tuning settings, Informix versions, OS versions, hardware systems, etc.
------------------------------
Art S. Kagel, President and Principal Consultant
ASK Database Management Corp.
www.askdbmgt.com------------------------------
Original Message:
Sent: Thu December 17, 2020 04:14 AM
From: Josef Albert
Subject: Informix OLTP benchmark
Hi Eric,
i forget to say that the benchmark will run under windows.
Is this possible?
Thanks.
------------------------------
Josef Albert
Original Message:
Sent: Thu December 17, 2020 02:56 AM
From: Eric Vercelletto
Subject: Informix OLTP benchmark
Hi Josef,
I have put a 'simili-tpc-c benchmark available in the IIUG Repository on sourceforge.
It is exactly done for that purpose
You need IDS and CSDK and gcc, because the bench is written in ESQL/C
Please private me if interested
Eric
Original Message:
Sent: 12/17/2020 2:14:00 AM
From: Josef Albert
Subject: Informix OLTP benchmark
Hi,
is there any tool available for benchmarking / comparing different servers?
I'm reading about BenchmarkSQL used by the fasted DBA contest...
But i can't find the fork that supports informix.
Thx.
------------------------------
Josef Albert
------------------------------
#Informix