You can use buffered inserts to improve the performance of inserting hundreds or thousands of records into a single database table as long as you don't need immediate feedback if an insertion failure occurs. You cannot use buffered inserts with interactive applications but you can use them with:
Table conversions
Table I/O
Batch processes
Business functions
Buffered inserts are not available with an Access database, post-insert triggers, or multiple-table views. They are available only with these databases:
Oracle (V8 and later)
DB2/400
SQL Server
The JD Edwards EnterpriseOne database middleware delivers records to the database management system one buffer load at a time.
When you request buffering, the database records are inserted individually and the buffer is automatically flushed when it fills; that is, the JD Edwards EnterpriseOne database middleware delivers the buffer to the database management system. The buffer can also be explicitly flushed. For example, the buffer flushes automatically when you commit a transaction or when you close a table or business view. The business function, table conversion engine, or Table I/O feature can explicitly request that the buffer be flushed as well.
* Using Buffered Inserts in Table I/O
Open a batch application in RDA and access Event Rules Design.
Click the Table I/O button.
On the Insert TableIO Operation form, select Open under Advanced Operations and click Next.
On the Data Source form, select the table that you want to use and click Advanced Options.
On the Advanced Options form, select Buffer Inserts and click OK.
* Using Special Operations for Buffered Inserts
Open a batch application in RDA and access Event Rules Design.
At the point in which you want to perform either a Flush Insert Buffer or Get Error Data operation, click the Table I/O button.
On the Insert TableIO Operation form, select one of these options under Special Operations:
Flush Insert Buffer
Get Error Data