Forum Post: Time Taken In Calling .p Files And Persistent Procedures.

  • Thread starter Thread starter nilesh_pharate
  • Start date Start date
Status
Not open for further replies.
N

nilesh_pharate

Guest
I am running progress code on broker (running on AIX machine) . Using progress 10.2B. when code gets executed I noticed that there is lot of time taken just to call .p file or persistent procedure. Time taken is around 8 to 40 seconds. I have few questions regarding same. 1. Is this related to memory leak. I have tried to avoid any memory leak by using single copy of persistent procedure, deleting unused procedures etc. 2. Do I need to increase stack size (-s parameter) , as I am passing lot of information through temp-tables to these procedures or .p files ? But I did not see any stack overflow error till now in logs. Request processing getting completed without any error but its taking time. 3. Do I need to increase heap size (-jvmargs parameter) ? But I did not notice any hep size error also. 4. Does this is related to resources available on server (memory, CPU etc) ? Do I need to re-configure those things on server? If anyone has faced same situation, Your findings or solutions are much appreciated. Thanks in advance.

Continue reading...
 
Status
Not open for further replies.
Back
Top