1. Alex Riofrio
  2. PowerServer
  3. Tuesday, 7 September 2021 17:03 PM UTC

Hello everyone;

Please, could you provide me more details about where or how to configure "Connection Pooling"?.

It also seems that the table to configure the timeout in different DBs would be missing in the documentation.

https://docs.appeon.com/ps2021/bk08ch04s05.html#d0e15706

 

Thanks in advance

Alex

Accepted Answer
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 8 September 2021 17:51 PM UTC
  2. PowerServer
  3. # Permalink
Hi Alex; Connection Pooling .... ASA (ODBC) .......... ODBC layer Oracle .... PowerServer SQL Server ..... PowerServer Regards ... Chris
Comment
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 7 September 2021 17:20 PM UTC
  2. PowerServer
  3. # 1

Hi Alex;

  The main thing to remember is that PowerServer's "Connection Pooling" does not work with ODBC connected DBMS. Instead, the Connection Pooling must be done within the ODBC Manager for the related DSN. Otherwise connection pooling could be off for those type of DB connections - even though PS's setting is ON (>0).

  The maximum amount of CP'ing will be related to the maximum number of concurrent App threads you anticipate. The minimum should be set for the expected low thread activity that your PS Apps could have. So say for example 5,000 App users where the low end threads are 0 and the high end is 1,000 - I would suggest MIN 5 and MAX 1000.

HTH

Regards ... Chris

Comment
There are no comments made yet.
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 7 September 2021 17:44 PM UTC
  2. PowerServer
  3. # 2

Hi Alex, What database are you using?

Comment
There are no comments made yet.
Alex Riofrio Accepted Answer Pending Moderation
  1. Tuesday, 7 September 2021 20:08 PM UTC
  2. PowerServer
  3. # 3

Hello Armeen;

ASA (ODBC)

Oracle

SQL Server

Comment
There are no comments made yet.
Alex Riofrio Accepted Answer Pending Moderation
  1. Tuesday, 7 September 2021 20:17 PM UTC
  2. PowerServer
  3. # 4

Thanks Chris for your answer.
Do you have any comment about SQL Server or Oracle connections?, Does we need to make the "Connection Pooling" configuration in each Database Client or in the Web API PS Solution?

Comment
  1. Alex Riofrio
  2. Tuesday, 7 September 2021 20:30 PM UTC
Thanks Chris.
  1. Helpful
There are no comments made yet.
Julie Jiang @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 8 September 2021 05:55 AM UTC
  2. PowerServer
  3. # 5

Hi Alex,

Thanks for catching the mistake in the document.  We will update it right away.

Regarding the command timeout settings, please note that we would recommend configuring the timeout values for transaction, session and request in the AppConfig>Application.json file in the ServerAPIs project. It is not best practice to modify the default settings directly in the database.

Best regards, Julie 

Comment
There are no comments made yet.
Alex Riofrio Accepted Answer Pending Moderation
  1. Wednesday, 8 September 2021 17:50 PM UTC
  2. PowerServer
  3. # 6

Thanks Julie for your kind answer.

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.