Bug #61647 | Executing stored procedures with input parameters performance decreased by 20% | ||
---|---|---|---|
Submitted: | 26 Jun 2011 19:38 | Modified: | 4 Jul 2011 19:00 |
Reporter: | Pavel Bazanov | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | Connector / NET | Severity: | S3 (Non-critical) |
Version: | 6.3.7 | OS: | Any |
Assigned to: | Bogdan Degtyariov | CPU Architecture: | Any |
Tags: | IN, input, Parameters, params, performance, slow, SP, stored procedures |
[26 Jun 2011 19:38]
Pavel Bazanov
[4 Jul 2011 10:10]
Bogdan Degtyariov
Pavel, Your test is not entirely correct. 1.4s and 1.6s is still within the experiment error. Try increasing the number of iterations from 10K to 100K and you will see the results are pretty even. I measured the performance for versions 6.3.6 and 6.3.7 and the result intervals were overlapping: 6.3.6: 12652ms..12754ms 6.3.7: 12715ms..12760ms
[4 Jul 2011 19:00]
Pavel Bazanov
Why is my test is not entirely correct? I get similar results with 100000 iterations: 6.3.6: 11345 ... 11600 6.3.7: 12346 ... 12826