Reported By: Ken Cole Reported On: 11/4/2000 For: Version 2.04 Build 1
# 653Repeatedly 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 and WorkaroundsThe workaround, if at all possible, would be to use a parameterized query.
ResolutionFixed Problem on 11/8/2000 in version 2.05 build 1