RE: SQL vs "native" I/O performance

RE: SQL Insert

To get the fastest results, you need to use blocked Insert:

  Insert Into T
         n Rows
         Values( :RowArray )

and system blocking (OVRDBF command SEQONLY parameter). Be sure it's not
disabled (e.g., by trigger programs).

For realistic results, I suggest larger rows and tables, with a mixture of
data types. Avoid runs of keys. Be sure you're not getting unnecessary data
type conversions. Etc. (SQL performance is a large issue, as you say, beyond
the scope of this forum.)

-- Paul

+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---