Optimizing database server performance

Setting appropriate values for the database parameters based on the actual needs can reduce the occurrence of database deadlock and block hence can improve the concurrency and stability of the Web application.

Common database optimization techniques include: optimizing the table structure, using proper index, and optimizing SQL statement. Additionally, check the following database server settings:

Connection Pooling

Instead of opening and closing connections for every request, connection pooling uses a cache of database connections that can be reused when future requests to the database are required. For example, right now the connection pooling is enabled by default for SQL Anywhere if the database server is on the same machine as PowerBuilder. If SQL Anywhere is on a different machine, you need manually enable the connection pooling.

Command Timeout

Setting appropriate timeout period for commands based on the actual needs can reduce the occurrence of database deadlock and block. You may set the timeout values for transaction, session, and request in the PowerServer C# solution > ServerAPIs project > AppConfig > Applications.json file.