Re: Oracle speed

Consider bypassing the BDE by using Oracle Direct Access nonvisual componets (http://www1.tip.nl/~t114789/doa.html). They are inexpensive and easy to install and use. You can even download a free evaluation copy. Once you've downloaded the software, look at the documentation .... it has specific info on calling stored procedures. Both of these methods may help you.

Anthony DeLuca <adeluca_at_fyi.net> wrote in article <34670A91.A4D59F88_at_fyi.net>...
> 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