How fast is Oracle ?
Date: 1996/02/07
Message-ID: <pirRZCAsqTGxEw6O_at_juno.demon.co.uk>#1/1
Can anybody suggest a rough estimate of the speed of Oracle 7.1 ? The company I work for is considering Oracle for the development of a real time system to record share price data. It needs to be able to receive about 300 data items per second from an external source and update corresponding records in an Oracle table (ie 300 update statements per second). The table has three integer fields. One field is changed on each update. Changes are committed after every hundred updates.
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.
We did notice a great deal of disk access by the log writer process which seemed to slow things down. Should this process only write after a COMMIT ? We have tried speaking to Oracle support in the UK but they have not been able to offer much help. We are now considering trying other databases such as Ingres to see how they compare.
I will be very interested to receive any thoughts or comments anybody
may have.
--
Richard
Received on Wed Feb 07 1996 - 00:00:00 CET