Re: Performance

Stephan,
  You stated that no data is retrieved from it on a form, so this might not be the problem. It's very easy to overlook a trigger that populates a dropdown list. If a trigger is using that table to populate a list or something similar, you'd see a performance degradation only when the table has lots of rows. Like I said, it's a long shot, but worth verifying.

HTH,
Roger Crowley - DBA - LearningFramework

"Stephan" <test_at_test.com> wrote in message news:Z7FZ8.83616$Un4.3185701_at_nlnews00.chello.com...
> Hi there,
>
> a question regarding speed.
> - winnt, Oracle 7.3.4
> - Oracle Forms 6i

snip
>
> ==================================
> All (say 10) our customers have no complaints against speed, except for 1:
> When we import the exports coming from our customers on 1 machine
(different
> instances, same parameters and tablespaces) in our office we conclude they
> all perform the same (as one would expect). The number of records the
> customers have inside the tables is almost the same, the structure is
> exactly the same, so it would be strange if there were big differences in
> speed.
> But 1 of our customers has slow speed. And yes, when we import that
database
> into an instance we also see poor performance!
> The main difference to the other databases: there is 1 table -containing
> 50.000 records- which has 0 records in all the other -fast- databases.
>
> --->But the STRANGE thing: can this table delay the working of Forms even
no
> data is retrieved from it on a form?
>
> --> How can I find the bottleneck?
>
> --> Other suggestions (for example concerning storage params)?
>
> Thanks
> Stephan
>
>
>
>
>
>
>
Received on Sun Jul 21 2002 - 10:31:06 CDT