Re: How fast is Oracle ?

From: Geoff Ingram <ingramg_at_boat.bt.co.uk>
Date: 1996/02/09
Message-ID: <4ffpm6$2fs_at_pheidippides.axion.bt.co.uk>#1/1


Richard Armstrong <richard_at_juno.demon.co.uk> wrote:
> [deleted]
>We have written a test application using a DEC Alpha machine running
>OpenVMS 6.1 and Oracle 7.1. The application is written in Pro*Pascal
>and it can only manage around 20 or 30 updates per second. We don't
>know whether this is the maximum rate we can reasonably expect or
>whether further tuning effort is likely to yield improvements.

  If you profile your code by embedding ALTER SESSION SET SQL_TRACE that   will tell you if the problem lies in your code or in Oracle itself.

> [deleted]
>I will be very interested to receive any thoughts or comments anybody
>may have.
>--
>Richard

  Hard to make any comment without seeing your source code.

regards Geoff Ingram



all my own personal opinions Received on Fri Feb 09 1996 - 00:00:00 CET

Original text of this message