• Subject: RE: SQL vs "native" I/O performance
  • From: Paul Conte <pconte@xxxxxxxxxxxxxxxx>
  • Date: Wed, 5 May 1999 14:34:11 -0700 (PDT)

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
+---


As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.