Multi threading and ProC

Hello,

We have developed a program wich uses a RDBMS for storage. This is a multi-threaded program. First time we developed a Sybase interface. Now we also developed an Oracle interface. And now comes the strange thing:

When we enable multi-threading in our application we get a performance penalty more than 10 times of the single-threaded application.

Thus: we have the a program with one single thread, using a context and compilation is done with same command-line parameters (threads=yes) Enabling "EXEC SQL ENABLE THREADS;" in the source gives the penalty.

What is happening here?

Environment:
  Solaris 2.51 on SuperSparc
  Oracle: 7.3.2
  Pro*C/C++: Release 2.2.2.0.0

Any pointers or suggestions are welcome.

Please would you also send a copy of your reply by mail?

--

Berend Reitsma

  United Info B.V.         |  Phone: +31 (0)513 465200
  P.O. Box 10              |  Fax:   +31 (0)513 461588
  8408 ZH Lippenhuizen     |  Email: berend_at_united-info.com
  The Netherlands          |  URL:   http://www.asset-control.com/