Re: ORACLE Performance Questions

On Tue, 6 Oct 1998 14:57:06 +0200, "Daniel Gessnitzer" <gessnitzer_at_ipks.de> wrote:
Hi,

You should definitely use stored procedures as much as possible. You do have a dual p so if possible try to execute procedures twice. We have a very intensive sql-procedure and we changed it a little bit in order to run 4 seperate runs and the overall performance increased dramaticly.

Besides all this, check you're Oracle performance, like SGA, fragmentation, commit once or after each row etc..

Jeroen

>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 Sat Oct 10 1998 - 09:14:36 CDT