...
| Table of Contents | ||||
|---|---|---|---|---|
|
...
| English |
|---|
| The default Joget installation comes with minimal performance configuration as it aims to cater for installation on small machines, e.g., a local development PC. |
| Chinese |
|---|
默认的Joget安装具有最小的性能配置，因为它旨在满足在小型机器（例如本地开发PC）上的安装。 |
...
| Thai |
|---|
ด้วยการเปิดใช้งานบันทึกคิวรีช้าแบบช้าสามารถระบุได้ใน MySQL สิ่งนี้จะช่วยระบุดัชนีและการเพิ่มประสิทธิภาพที่เป็นไปได้ |
Microsoft SQL Server Configuration
In MSSQL, adaptive buffering is designed to retrieve any kind of large-value data without the overhead of server cursors. You can configure the JDBC URL to use SelectMethod=direct in the database property file ".\wflow\app_datasource-mssql.properties" [Rename the "mssql" according to your environment].
For example, the current string is:
workflowUrl=jdbc\:sqlserver\://localhost\:1433;SelectMethod\=cursor;DatabaseName\=jwdb
Change it to:
workflowUrl=jdbc\:sqlserver\://docker\:1433;SelectMethod\=direct;DatabaseName\=jwdb
Please remember to perform full testing on the SelectMethod option in your development or staging servers before implementing it in production server.
Reading: https://docs.microsoft.com/en-us/sql/connect/jdbc/using-adaptive-buffering?view=sql-server-ver15
Clustering and Load Balancing
...