Re: Help! Server Tuning/speed/optimization

From: vsaksena <vsaksena_at_us.oracle.com>
Date: 1997/09/04
Message-ID: <340E731A.2EAD@us.oracle.com>#1/1

Saunnie,

        Why would you want to retrieve 1000 records from an OLTP front end ? If a large fraction of your users are going to access 1000 records/sec, this can easily saturate any available capacity on your machine. Anjo makes a good point about determining if this is actual service time or wait time.

---

Virag Saksena vsaksena_at_us.oracle.com
Senior Principal Consultant 650.506.5087
System Performance Group
Oracle Services

---

Saunnie McGee wrote:
>
> Does anyone know of some simple strategies for optimizing a database?
>
> Queries that return under 1000 records take about 1 minute. In user time
> that's way too long. We have an average of 20,000 records in the tables we
> are testing. We are using a Developer 2000 (forms 4.5) front end and the
> database is version 7.3.2.2.1.
>
> saunnie_at_gcr1.com
  Received on Thu Sep 04 1997 - 00:00:00 CDT