-
mike S
- PowerServer
- Monday, 19 February 2024 07:41 PM UTC
PS 2022R2 2828
Recent testing of Powerserver applications where the client workstation was over 2500 miles away from the data center showed excellent response times for typical screen processing and data entry. This included search as you type response time (where the database is searched after a keystroke), as well as retrievals of a several thousand row datawindow. This was much faster than expected. The client workstations involved did have high speed fiber internet connections however.
Slowness (compared to client server) is generally where you should expect it most - processes that update/insert/delete/select the database many times in a loop. Appeon does provides the PowerServerLabel object to batch together multiple database calls which should help certain processes. But for the best performance changing those processes over to a server hosted process that is called via a REST api generally provides at least one order of magnitude of performance increase. It also allows for a 'fire and forget' processing that starts the process on the server and then returns control immediately to the user (or starts it, waits for a few seconds to see if it finished and if not returns that it is still processing). That is for server based processes that are powerbuilder applications. Changing those over to pure c#/snapdev may provide additional performance increases, but probably not anywhere near as great as simply changing where the processes run.
We had also added various caching to our application. With these changes, a screen that can take 2-3 seconds to open the first time it is opened, will drop to under a second after the initial open. (This is runtime caching, meaning each time you log in you have the initial hit of caching.) This caching in particular has made a huge difference to our customers, particularly those who did not have fiber internet connections.
special thanks to Ronnie P. for participating in the performance testing.
thanks to appeon for continuing to improve the performance and functionality of powerserver
Find Questions by Tag
Helpful?
If a reply or comment is helpful for you, please don’t hesitate to click the Helpful button. This action is further confirmation of their invaluable contribution to the Appeon Community.