APPX is the Premier Development and Runtime Environment for Business Application Software
(Answer) (Category) FAQ's - APPX Software, Inc. : (Category) APPX Utility : (Category) APPX System Administration :
Oracle import performance issues.
When APPX imports records into an Oracle database, APPX reads a record from the source file and then executes a SQL INSERT ROW statement to insert the row (record) into the Oracle database. With every insert, APPX executes a commit statement. The environment variable APPX_IMPORT_COMMIT can be set to change the commit frequency if necessary. Example:
                     export APPX_IMPORT_COMMIT=5000
An INSERT ROW statement also updates the indexes that are defined for the Oracle table. Inserting individual rows of data and updating the indexes is probably the slowest operation that you can perform with a database.
Performance of the import operation can be improved dramatically by removing the indexes from the Oracle table. After the data is imported, the indexes can be added back.

Another factor that can have a significant impact on performance is if your Oracle database resides on a different system than APPX. If APPX and Oracle are on different systems, each INSERT ROW statement is going to generate one or more TCP/IP transactions. Moving data thru a network can be painfully slow. APPX always recommends that you install APPX on the same system as your database if at all possible.

The only other suggestion is to have your DBA monitor the Oracle database and verify that all configuration settings that might affect performance are set appropriately.

[Append to This Answer]
2003-Nov-24 9:53am
Previous: (Answer) What rule does APPX / Oracle interface use to decide when a field will be "char" vs "varchar".
Next: (Answer) How to import dates from APPX to Oracle.
This document is: http://board.appx.com/cgi-bin/fom.cgi?file=158
[Search] [Appearance]
This is a Faq-O-Matic 2.719.
Copyright 2003 by APPX Software, Inc. All rights reserved.