tracker issue : CF-4098592

select a category, or use search below
(searches all categories and all time range)
Title:

CFQUERYPARAM performance issue in Coldfusion 10

| View in Tracker

Status/Resolution/Reason: Closed/Fixed/

Reporter/Name(from Bugbase): / ext-user (Rahul Upadhyay)

Created: 12/10/2015

Components: Database, CFQuery

Versions: 10.0

Failure Type: Unspecified

Found In Build/Fixed In Build: 10 /

Priority/Frequency: Normal / Unknown

Locale/System: English / Mac 10 All,Win All

Vote Count: 0

Issue detailed description:

http://stackoverflow.com/questions/31962522/reproducible-cfqueryparam-performance-issue-in-coldfusion-10

database -  MS sql

Output with creating the table with varchar - 

Execution time in CF9 � 5ms to 100 ms
Execution time in CF10  - 325ms to 536ms
Execution time in CF11 � 300ms to 448ms

And with nvarchar: 

Execution time in CF9 - 4ms- 37ms
Execution time in CF10 --   21ms to 124ms
Execution time in CF11 --  17ms to 129ms

EET notes:

DD Case is raised. Case ID: 00324512
Added repro case and opened the case #00329869

----------------------------- Additional Watson Details -----------------------------

Watson Bug ID:	4098592

External Customer Info:
External Company:  
External Customer Name:  
External Customer Email:

Attachments:

Comments:

[subscribe]
Comment by External U.
5109 | December 17, 2015 01:17:56 AM GMT
This issue is fixed now. The fix has been released as part of ColdFusion 10 Update 20, ColdFusion 11 Update 9 and ColdFusion 2016 Update2.
Comment by Nimit S.
5110 | June 20, 2016 10:31:55 PM GMT