DevOps, CI/CD and Automation

Hi,

I installed Oracle8.1.7 on my machine and setted up an odbc connection using
VC to the database. I created a statement adding records in the database using
the SQLPrepare and SQLExecute by setting some parameters.

It takes about 5 seconds to create 100 records! During this the PC is not so buisy.
Oracle has some of 1% CPU time and my application has lesser than 1% CPU.
If I look in the oracle trace file, it shows for this statement
parsing 1 times, executed 100 times, cpu 0,01
If I try a similar example using PL/SQL it adds 1000 records in one second.

What I'm doing wrong here and what is the key to get the odbc driver work
faster?
I already read the Oracle ODBC documentation and have done all the steps there,
like disabling the thread safe mode, but without any improvment.

thanks
khamis
khamis@web.de