1. mathews rutto
  2. PowerServer
  3. Thursday, 18 July 2024 01:51 AM UTC

My application is very slow when i am doing select, insert. When i am navigation from one window to another i don't have a problem with.

Where am i going wrong?

mike S Accepted Answer Pending Moderation
  1. Thursday, 18 July 2024 13:20 PM UTC
  2. PowerServer
  3. # 1

you need to determine where it is being slow.  some things to think about:

 

do you connect the client to the web api server via a local network, or internet/wan?  if internet/wan what does your latency look like?

is the database and the web api server in the same local network?

do you have a lot of selects that are occurring?  (either change to a lot fewer selects, use the PS batching, or use local caching)

did you sign your application?  If not, try turning off antivirus.

 

those are all just guesses.

you need to do performance tuning.  so you need to time your code to see what is slowest and start with that.

 

 

 

Comment
There are no comments made yet.
Sivaprakash BKR Accepted Answer Pending Moderation
  1. Thursday, 18 July 2024 05:42 AM UTC
  2. PowerServer
  3. # 2

Really vogue.  Better to inform us which version of PB, OS you use.  What action makes the slowness?  And where you find the slowness. 

1.  Have you tried finding any function / procedure that's taking long time.
2.  Any script in getfocus / activate event(s)
3.  How you say its slow?  Do you compare with app compiled with previous version(s)?  
4.  Have you checked with HDD?  Recently we faced this issue, once we replaced with new HDD, the issue resolved.

Happiness Always
BKR Sivaprakash

 

Comment
There are no comments made yet.
mathews rutto Accepted Answer Pending Moderation
  1. Monday, 29 July 2024 19:23 PM UTC
  2. PowerServer
  3. # 3

Thank you for the response,

I am using powerbuilder 2022r3, database PostgreSQL and web API runs over the internet.

Below is the server specs and performance from task manager.

internet

Comment
  1. Sivaprakash BKR
  2. Tuesday, 30 July 2024 11:50 AM UTC
Do you mean, your application uses API to fetch, insert, update, delete data ?

If yes, then it will be slower compared to datawindow retrieve

  1. Helpful
  1. mathews rutto
  2. Tuesday, 30 July 2024 12:01 PM UTC
I am using PowerServer. Yes, it uses API to fetch, insert, update, and delete data.



Is there any other way to make it faster?

  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.