OLE DB performance with Microsoft SQL Server – PB Docs 2022

In PowerBuilder 10.5.2 and later, when you use the OLE DB database
interface with a Microsoft SQL Server database and retrieve data into a
DataWindow or use an embedded SQL cursor in a SELECT statement,
server-side cursors are used to support multiple command execution. If
this has a negative impact on performance, try increasing the size of
the Block database parameter to 500 or more, or adding the following
line to the [Microsoft SQL Server] section in the PBODB initialization
file to turn off server-side cursors: ServerCursor = ‘NO’