Oracle speed

    I am working on a project using Delphi 3 for the front end, and Oracle 7 server for the back end. We
are have a problem with speed for doing inserts into tables. At certain points we are inserting up to
100,000 data file records into the database. There is information going into 3 tables from this database file.
It takes up to 35 minutes to do an insert this big. The current version of our software (which uses
Paradox / C) takes 3 minutes to do this insert.

    Can anybody give me any suggestions on how to go about making this faster? We are using the native
BDE Oracle driver to interface the database. I have been told about stored procedures, but have been
unsuccessful in using them. Is there some sort of software that may help us? Is there somewhere we
can have our code reviewed for optimization suggestions? Any help is greatly appreciated!!

Thanks in advance,
--Anthony DeLuca, Prograph Bindery Systems. Received on Mon Nov 10 1997 - 00:00:00 CET