Performance problem with WebDB
From: Ales Kavsek <kavsek_at_yahoo.com>
Date: Tue, 18 Jan 2000 17:49:11 +0100
Message-ID: <8625dq$dgl$1_at_sigov1.sigov.si>
Hello!
Date: Tue, 18 Jan 2000 17:49:11 +0100
Message-ID: <8625dq$dgl$1_at_sigov1.sigov.si>
Hello!
We are trying to build simple query form (table with 13 fields, 170000
records,
table is analyzed) with WebDB 2.1.0.9.3 / Oracle 8.1.5 / Windows NT / 4 CPU,
542MB machine.
What we would like to achieve is /*+ FIRST_ROWS */ behavior of query form
and response time under 10 s. Now it takes 1-3 minutes to return the first
row!
We tried to build form on top of view with /*+ FIRST_ROWS */ hint on
the same base table and response time remain the same. On the other hand
the response time with Forms 4.5 and SQL*Plus is under 2 s.
Any suggestion how to resolve this problem?
Thanks in advance for help !!
Ales Received on Tue Jan 18 2000 - 17:49:11 CET