• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerServer
  • Power Server 2022 latency issues on deployment

Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (2)

Resolved Power Server 2022 latency issues on deployment

  1. How-to
0
Votes
Undo
  1. Deepak Sharma
    Deepak Sharma
  2. PowerServer
  3. Thursday, 8 February 2024 12:05 PM UTC

We have migrated a PB 8.0 application to PB 2022 environment and deployed on IIS server uisng Power Server 2022.

PowerBuilder Code & database running on SQL Anywhere 17.0 are deployed on AWS environment.

Executing business logic code written using Data windows & Power scripting are having latency issues.

Executing a code for Inserting and updating a list of tables in database is consuming more time in Power Server environment with database setup on cloud server as compared to same code executed in Power Builder environment with database placed locally.

How can this be addressed to resolve latency issues.

Also, can Cloud Pro help in implementing business logic for a solution.

Thanks, in advance.

 

Change app name after deployed.
PowerServer - SQLCode return values during executi...
Responses (2)
Armeen Mazda @Appeon
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Thursday, 8 February 2024 14:04 PM UTC
  2. PowerServer
  3. # 1

Which build of PowerServer 2022 are you using?  Newer builds support PowerServerLabels, which is the least effort way to make your app run faster over latent network connections.

I recommend reading this section of the performance tuning guide to understand why your app is slower: https://docs.appeon.com/ps2022r3/Impact_of_the_Internet_and_slow_networks.html

And this section explains how easy it is to implement PowerServerLabels in your code: https://docs.appeon.com/ps2022r3/Grouping_server_calls.html

Comment
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 8 February 2024 14:00 PM UTC
  2. PowerServer
  3. # 2

Hi Deepak;

  Yes, N-Tier based Apps / developers need to be cognitive of processing differences compared to a C/S (2 tier) computing model. Then of course, you've added the Cloud platform overhead / latencies as well to your overall computing model. Both of these aspects need to be accounted for (and tuned accordingly) to meet expected App service levels.

 FYI: https://docs.appeon.com/ps2022/performance_guide.html

HTH

Regards ... Chris 

Comment
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.