Kbase 20581: How do "Binding" variables function in ODBC/MS SQL DataServer?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
GOAL:
How do "Binding" variables function in ODBC/MS SQL DataServer?
GOAL:
What does -Dsrv BINDING do?
FACT(s) (Environment):
Progress 9.1x
OpenEdge 10.x
MS SQL DataServer
ODBC DataServer
All Supported Operating Systems
FIX:
Binding variable are a new implementation in Progress 9.1B, thus the new feature should not change the product functionality as they serve more of a performance enhancement.
The new implementation introduced a new DataServer switch (-Dsrv BINDING) to control the use of bind variables.
The behavior can be changed as follows:
-Dsrv BINDING,0 => No Binding
-Dsrv BINDING,1 => NO-LOCK Binding
-Dsrv BINDING,2 => EXCLUSIVE-LOCK Binding
-Dsrv BINDING,3 => Both NO-LOCK and EXCLUSIVE-LOCK Binding
The value 3 is the default, so bind variables will be used for all NO-LOCK and EXCLUSIVE-LOCK queries.
This parameter must be used at the DataServer connection parameters.
Testings show that the performance gain/loss with binding on/off is around 5%.