Icon View Incident Report

Serious Serious
Reported By: Carlton Craighead
Reported On: 8/6/2008
For: Version 2.01 Build 4
# 2734 Setting the EDBCommand CommandText Property with ParamCheck=True Causes Long Delay

There's an issue with slowness during the assignment of the SQL code to the command’s CommandText property. On my very fast machine, when I single step that line for the SQL code in the file attached here, it takes about 80 seconds and runs my quad core 3GHz at about 28% the entire time. The same test on my test machine fares much worse: 378 seconds at 48% the whole time. Because of where this was (in the transaction), it was killing access to the entire database.


Comments Comments and Workarounds
The issue was the parameter parsing due to the EDBCommand ParamCheck property. The workaround is to set ParamCheck to False and populate the parameters manually.


Resolution Resolution
Fixed Problem on 8/6/2008 in version 2.01 build 1


Products Affected Products Affected
ElevateDB DAC Client-Server
ElevateDB DAC Client-Server with Source
ElevateDB DAC Standard
ElevateDB DAC Standard with Source
ElevateDB DAC Trial

Image