Title:
cfquery's coldfusion.tagext.sql.QueryTag.maskDateTimeColumns() is slow with sandbox security enabled
| View in TrackerStatus/Resolution/Reason: Closed/Withdrawn/Duplicate
Reporter/Name(from Bugbase): Henry Ho / Henry Ho (Henry Ho)
Created: 07/21/2016
Components: Performance
Versions: 11.0
Failure Type: Performance Issue
Found In Build/Fixed In Build: CF11_Final /
Priority/Frequency: Major / All users will encounter
Locale/System: English / Win All
Vote Count: 0
Duplicate ID: CF-4173670
Problem Description:
VisualVM hotspot trace shows that coldfusion.tagext.sql.QueryTag.maskDateTimeColumns() from <cfquery> invokes java.lang.System.getProperty() which is slow with sandbox security enabled
Steps to Reproduce:
Use <cfquery> with sandbox security on, and do a cpu snapshot to see trace
Actual Result:
-> coldfusion.tagext.sql.QueryTag.setQueryResult()
-> coldfusion.tagext.sql.QueryTag.maskDateTimeColumns()
-> java.lang.System.getProperty()
Expected Result:
- no repeated calls to java.lang.System.getProperty() which causes a permission check from Security Manager
Any Workarounds:
turn OFF sandbox security for performance.
----------------------------- Additional Watson Details -----------------------------
Watson Bug ID: 4174749
External Customer Info:
External Company:
External Customer Name: Henry Ho
External Customer Email:
External Test Config: My Hardware and Environment details:Attachments:
Comments: