Perfomance Issue

[greeshma]

From a gui program , with appserver routine i am calling a program in character.

CREATE SERVER hAppServer.
v-as-connected = hAppServer:CONNECT( g-aspf-val )
                       NO-ERROR.
  empty temp-table tt-sales.
  RUN asloadTT.p ON SERVER hAppServer
                        (OUTPUT TABLE tt-sales,
                        INPUT curr-cruise).

Even if i am passing same input, processing time varies a lot.
Some times it takes microseconds and sometimes 20 seconds.

I am the only user currently using this enviornment.No errors found in appserver log.
I am using progress openedge 10.2B . Please help me to find out the reason for this performance issue.

 

[GregTomkins]

Put some timing code around the CONNECT vs RUN to isolate which one is taking a while. My guess is: the problem is in the CONNECT, and it's because your network and/or DNS has some issue.

 

[TomBascom]

There could also be very big variations that depend on the amount of data returned in the temp-table and/or the amount of effort required to execute whatever asLoadTT.p does. A cruise in my canoe can likely be processed a lot faster, and return a lot less data, than a cruise on "Allure Of The Seas".