• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerServer
  • Theorical question: Long SQL Task / Large Result set vs Powerserver

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

Resolved Theorical question: Long SQL Task / Large Result set vs Powerserver

  1. Advice
0
Votes
Undo
  1. Mathieu Normandeau
    Mathieu Normandeau
  2. PowerServer
  3. Monday, 29 August 2022 20:29 PM UTC

Hi,

I'm evaluating the feasability/cost of upgrading some of our Powerbuilder Application to PowerServer 2021+.

I used an evaluation licence, but unfortunatly, it's not a straight forward as expected for our application, so I wasn't able to test this scenario.

I would like to know what will happen if an existing sql query took minutes to be executed.

Usually, when we call an API and it took more than few seconds, we have some timeout. 

Does that will be the case with Powerserver?

If not, does that will lock Powerserver for others users?

 

 

Also, mostly for reporting, we have few sql query that return lots of data (>10  megs)

What will happen?

 

Thanks,

PowerServer 2022 and Windows Active Directory
Precision about PowerServer 2022 Roadmap
Responses (4)
mike S
mike S Accepted Answer Pending Moderation
  1. Tuesday, 30 August 2022 03:37 AM UTC
  2. PowerServer
  3. # 1

PS settings:

cache connection time outs: ConnectionTimeout CommandTimeout

application configuration time outs: RequestTimeout, SessionTimeout, TransactionTimeout

if you still have time out issues, also see:

c# - How to increase executionTimeout for a long-running query? - Stack Overflow

 

Also see article from appeon, although it is not exact anymore since this is PS2020 and below, but this does talk about that timeout as well.

https://support.appeon.com/index.php?/Knowledgebase/Article/View/117/11/web-service-request-timeout-settings

Comment
mike S
  1. mike S
  2. Tuesday, 30 August 2022 03:52 AM UTC
the CommandTimeout is the first setting to change. I set it to 600 for long running database queries.
  1. Helpful
Logan Liu @Appeon
  1. Logan Liu @Appeon
  2. Tuesday, 30 August 2022 06:56 AM UTC
Hi Mathieu, I think Mike's answer is great. I just want to add more tips:

1) For connection-level timeout, you can find and configure them in the Database Configuration - Advanced settings.

2) If you want to get more details about these application-level timeout settings (Request Timeout, Session Timeout, Transaction Timeout), please refer to https://docs.appeon.com/ps2022/Configure_timeout_settings.html

3) For your concern about the possibility of locking other users, you ONLY need to make sure your native PB application has fixed all of the database transaction locking issues.

Regards, Logan

  1. Helpful
There are no comments made yet.
mike S
mike S Accepted Answer Pending Moderation
  1. Tuesday, 30 August 2022 03:48 AM UTC
  2. PowerServer
  3. # 2

Also, you get a powerserver development license with powerbuilder.  

Comment
Logan Liu @Appeon
  1. Logan Liu @Appeon
  2. Tuesday, 30 August 2022 07:38 AM UTC
Hi Mike, thanks. But I think this description of the PowerServer Development License is not accurate if you are not using the PowerBuilder CloudPro license.

1）If you already have a PowerBuilder CloudPro license (no matter which version it is), the CloudPro license will automatically work with the GA version. Each PowerBuilder CloudPro subscription includes a developer license of PowerServer, which supports a maximum of 5 user sessions (one user session = one single instance of an installable cloud app). You will need to purchase a production license of PowerServer in order to use the production server and more user sessions.

2) If you have no PowerBuilder CloudPro license, you can apply for a trial license at https://www.appeon.com/psfreetrial, or purchase a production license of PowerServer from https://www.appeon.com/pricing.

Refer to: https://docs.appeon.com/ps2021/Import_license_and_activate_PowerServer.html

Regards, Logan

  1. Helpful
mike S
  1. mike S
  2. Tuesday, 30 August 2022 13:02 PM UTC
You need CloudPro to deploy to powerserver. the trial is for cloudpro. buying a production license of powerserver does not get you cloudpro.



Mathieu - the short answer is that this stuff works.



I recommend upgrading to cloudpro now so that you can continue working on getting it to run on the development powerserver license. Once that works, you can buy the production license of powerserver.



Also, move to PS/PB 2022 as soon as it is released as there are a nice set of enhancements to PS.







  1. Helpful
There are no comments made yet.
Erin Guillen @Appeon
Erin Guillen @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 30 August 2022 14:13 PM UTC
  2. PowerServer
  3. # 3

Hi Mathieu, good day!

I would recommend evaluating PowerServer 2022 instead.

It has some improvements that may address the timeout issue you are concerned about.

The GA version of PowerBuilder/PowerServer 2022 is scheduled to release in just a couple of weeks.

In regards to the expired trial, please email trial@appeon.com our team can provide you with a fresh trial so you evaluate v2022.

Comment
There are no comments made yet.
mike S
mike S Accepted Answer Pending Moderation
  1. Tuesday, 30 August 2022 15:49 PM UTC
  2. PowerServer
  3. # 4

"we have few sql query that return lots of data (>10  megs)"

you can run small reports of 10 mb of data, as well as larger reports of 500MB + of data.   Once you get over 1GB you may want to consider 64 bit version of the client so you don't run out of memory.  Just like regular PB.   

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.