Re: How fast is Oracle ?

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