Re: Re[2]: SPEED-UP OPERATION

The problem with finding the bottleneck is that the users are not using the application because it is so slow. The=20 database is a reference library of sorts. Even when in use,=20 only three or four users at a time may be adding entries. =20 I'm not sure of the number of users querying the database,=20 but it would only be a few a day generally.

For the moment, the users are recording the information on paper for later entry into the database.

So, how the heck do I figure out what is wrong?

I asked the users to do some work in the application for a few hours a couple of weeks ago and found absolutely no problems=20 with IO, cpu, or anything else I could think of to check. I used bstat/estat and a variety of performance tuning scripts. It can take minutes (3 to 10) for an insert or update via the application,=20 and even switching between forms takes 30-60 seconds, but the SQL involved runs in hundredths of a second when run on its own.

Sigh. I think I'm going to have to learn Oracle Forms next so that I can figure out what is going on.

>>> stephane_paquette_at_yahoo.com 6/2/2000 >>> Have you identified a specific bottleneck ? Is it IO or cpu ?
How do you checked the SQL ? Personnaly I used tkprof.

=20

• Kristen Cameron <cameronkgd_at_inac.gc.ca> a =E9crit :
  > I'm trying to speed up an application built using
  > Forms 4.5. I have extracted
  > all the SQL executed by the application (30+
  > statements) and am checking
  > them, but see no problems thus far. I have already
  > checked the usual suspects
  > (hit ratios, swapping and paging, etc.) and have
  > discovered that the
  > database itself runs beautifully!
  >=20
  > Is it possible that the coding within the Form
  > itself causes it to run slowly?
  > I don't mean the SQL code, but the code that Forms
  > uses. There are=20
  > triggers etc. built into the forms that do not
  > access the database.