Re: ORACLE Performance Questions

Hi Daniel,

    Be sure to check your alternatives on the client side. We were suffering a performance problem -- 13 seconds to retrieve a record. I extracted the query statement and ran it from the command line with timing set on to see how long the server was taking -- under 1/100th of a second. Then we looked at the network and the client software. It turns out that all of the time was being spent in ACCESS on the client PC. The client software was rewritten in Visual Basic 5 and overall time dropped to about three seconds.

Regards

Jerry

Daniel Gessnitzer wrote in message <6vd43q$pl9$1_at_news.axis.de>...
>Hello
>We are use ORACLE 7.3 Workgroup Server on Win NT Server (dual P150).
>Our client transfers Data from an older production database system and
>writes every Record with an single Update Statement into one row (via an
>ODBC connection). We have measured 30 milliseconds per Statement which is
to
>slow for our application. We must write ca. 100 records per Second, so we
>need an time delay of 10 ms per statement. In this environment we has the
>following questions:
>
>1. What kind of update method is the best
> a. stored procedure
> b. prepared Statement
> c. unprepared Statement via SQLExecDirekt()
>
>2. Which datatype for numerical integer data is the fastet that ORACLE can
>handle?
>
>3. Is multithreading on clientside, which one thread per statement (and
>Connection)
> a possible solution and is the current available ORACLE ODBC driver
>Threadsafe?
>
>4. Is there an good book outside targeting this kind of problems?
>
>thanks in advance
>
>Daniel
>
>--
>Daniel Gessnitzer
>gessnitzer_at_ipks.de
>home of the rhino screensaver:
>http://www.geocities.com/SiliconValley/Horizon/9473/
>
>
>
Received on Wed Oct 07 1998 - 11:52:27 CDT