Re: Oracle speed

On Mon, 10 Nov 1997 13:22:25 GMT, Anthony DeLuca <adeluca_at_fyi.net> wrote:

> 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.
>
My Advice is to use stored procedures as the first option, also make sure the oracle server has been optimised(Ask your System Administrator for Advice) Received on Tue Nov 11 1997 - 00:00:00 CET