RE: Interesting Benchmarks -- SQL, RPG, Journaling, and Triggers

["Walden H. Leverich" <WaldenL@xxxxxxxxxxxxxxx>]

Something's very wrong. 

I find it hard to believe, but I'd accept it, that RPG beats out a
single sql statement, by 2:1 when there's a trigger, as shown in the
last set of tests. However, I simply cannot believe that SQL w/a cursor
beats out SQL w/out a cursor, again by 2:1. That makes no sense.

Also, I wonder if it would be different using a SQL trigger, especially
one registered as FOR EACH STATEMENT instead of the default FOR EACH
ROW.

Very odd indeed.

-Walden

--
Walden H Leverich III
Tech Software
(516) 627-3800 x3051
WaldenL@xxxxxxxxxxxxxxx
http://www.TechSoftInc.com

Quiquid latine dictum sit altum viditur.
(Whatever is said in Latin seems profound.)