Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Poor Insertion Performance

Re: Poor Insertion Performance

From: Thomas Olszewicki <ThomasO_at_cpas.com>
Date: Wed, 05 Jan 2000 19:35:19 GMT
Message-ID: <X1Nc4.2591$eQ2.100060@news1.rdc2.on.home.com>


Steven,
From my experience: Oracle should perform better than MS SQL on same platform.
In your case you may want to inspect your ODBC setting for Oracle. Use latest ODBC driver for Oracle from MS. Free download from MS site.

Thomas

"Steven Booth" <steven.booth_at_qmark.co.ukNOSPAM> wrote in message news:947069977.19535.0.nnrp-04.c29f1ea1_at_news.demon.co.uk...
> Any help or suggestion would be greatly appreciated.
>
> We have used scripts to create tablespaces, tables, indexes and triggers.
We
> then use C++ code which populates a database using ODBC. Therefore, our
C++
> code does not know if we are populating an Access, Oracle or SQL database.
> Under SQL the populating of the tables works fast. As more data is
inserted
> into the SQL tables the speed of populating does not take considerably
> longer. However, under Oracle we find that when we have empty tables even
> then you are waiting 4x times as longer to populate the table compared to
> SQL. Therefore, as the Oracle tables grow bigger it can take a very long
> time to add the data to the Oracle tables.
>
> Now I think there are a couple of things that can explain this
>
> The scripts we have used to generate the tables in Oracle have an error in
> them. But I am not sure where.
> The scripts are OK but we need to do some tuning to the Oracle setup to
make
> things work faster. I had a look for Oracle books and found there are lots
> which explain how to tune your Oracle database. This made me think maybe
> there is a setup issue for Oracle which we have not addressed.
> Our C++ code, which uses ODBC, does not really care on the database engine
> needs to be changed specifically to deal with Oracle. However, I really
> believe that this is not where the problem lies. But I have open to
> suggestions on this.
>
> Any help or suggestion would be greatly appreciated.
>
> Regards
>
>
>
Received on Wed Jan 05 2000 - 13:35:19 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US