RE: sql exec speed. was AS/400 STILL wearing the undeserved "closed system" moniker

And lest ye think I'm not being as impartial as possible here, I did some
research on the block INSERT technique, and can report that it greatly
increases performance.  By adding a blocking factor of 10, I reduced the SQL
processing time from 40 seconds to 6 seconds for inserting 100,000 records.
Implementing this technique involves using a multiple occurence data
structure.  The problem, of course, is that you have to have blocks of
records to insert, and normal transaction processing doesn't work that way,
but in those cases where it's appropriate, it certainly makes SQL process
better.

Unfortunately, I didn't come across an analogous operation for updates, so
the FETCH/UPDATE numbers still stand.

Joe


> -----Original Message-----
> From: Joe Pluta
> 100,000 WRITE operations took 7 seconds
> 100,000 SQL INSERT INTO ... VALUES operations took 40 seconds