Poor Insertion Performance

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 - 05:01:13 CST