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 :
Importing big Oracle tables!
If your tables are large &/or have numerous indexes, the following can speed up the import significantly:

After using APPX to create the table in Oracle (and presumably other RDBMS's), use SQL PLUS or any other DBA tool to drop all the table's indexes. Then import the data -- it will import much faster.

Important: Your Appx import should use the "merge" option. Otherwise, APPX scratches/creates before importing, recreating the indexes that you just dropped, and eliminating the performance boost you want during the import.

After importing, tell APPX to 3)Create the table again. APPX won't create the table since it already exists, but will create the missing indexes much more quickly than if you had built the indices one row at a time.

[Append to This Answer]
2004-Jan-05 4:25pm
Previous: (Answer) Where is Java/Client cache?
Next: (Answer) What is my AppxODBC version?
This document is: http://board.appx.com/cgi-bin/fom.cgi?file=270
[Search] [Appearance]
This is a Faq-O-Matic 2.719.
Copyright 2003 by APPX Software, Inc. All rights reserved.