Kbase P187639: Does scrolling open queries degrades performance of the DataServer application running against MS SQ
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
23/05/2011 |
|
Status: Unverified
GOAL:
Does scrolling open queries degrades performance of the DataServer application running against MS SQL Server?
GOAL:
Does scrolling open queries performs slower when ran against MS SQL Server DataServer?
FACT(s) (Environment):
Windows
OpenEdge 10.x
MS SQL DataServer
FIX:
NO-LOCK scrolling queries will not see any performance degradation when run against MS SQL Server Database. If the ABL client connection parameters includes -Dsrv TXN_ISOLATION,1, the SHARE-LOCK queries will also have no performance hit using scrolling queries.