Re: How fast is Oracle ?

there are lots of variables in this. 1. using sql*net v2? 2. doing joins? 3. using indexes on the table? 4. clustering keys? 5. can your lan support the amount of data you want to push?

indexing slows inserts, speed queries, joins slow queries, clustering speeds queries if indexes are clustered. lan/middleware is critical, make sure oracle has a lot of memory, possibly cache enlargement.

---

In article <4ffpm6$2fs_at_pheidippides.axion.bt.co.uk>, Geoff Ingram
<ingramg_at_boat.bt.co.uk> wrote:



> 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