Icon View Incident Report

Serious Serious
Reported By: Ken Cole
Reported On: 11/4/2000
For: Version 2.04 Build 1
# 653 Repeatedly Executing Different Dynamically-Built SELECT Statements Causes Slowdown Over Time

I have noticed a somewhat severe slowdown with calls to a dynamically built query. The following example runs in < 10 ms the first time, but slows down rapidly with each successive call:

- At 100 runs, it takes 60 ms.
- By 200 runs, it's taking 170 ms.
- By 300 runs, it's up to 370 ms.
- You get the idea

The slowdown is worse than linear, as you can see.


Comments Comments and Workarounds
The workaround, if at all possible, would be to use a parameterized query.


Resolution Resolution
Fixed Problem on 11/8/2000 in version 2.05 build 1
Image