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: email@example.com +---
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.