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 -> Multi threading and ProC

Multi threading and ProC

From: Berend Reitsma <berend_at_united-info.com>
Date: 1997/05/01
Message-ID: <3368722B.B67F309@united-info.com>#1/1

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/
Received on Thu May 01 1997 - 00:00:00 CDT

Original text of this message

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