Look in MIDRANGE-L, search for "sql exec speed", and you should find them.
INSERTs take nearly six times as long as WRITEs, while FETCH/UPDATE takes
four times as long as READ/UPDAT. Here's an excerpt:
WRITE Test:
100,000 WRITE operations took 7 seconds
100,000 INSERT INTO ... VALUES operations took 40 seconds
0.07 msec/WRITE
0.40 msec/INSERT
Not two orders of magnitude, but still a very poor performance from SQL.
UPDATE Test:
100,000 READ/UPDAT operations took 10 seconds
100,000 SQL FETCH NEXT/UPDATE WHERE CURRENT operations took 40 seconds
0.10 msec/UPDAT
0.40 msec/UPDATE
> -----Original Message-----
> From: Mangavalli, Ramanujam
>
> Joe, Can you please point me to where you posted your results ?
> Thanks.
