Slow database performance - Windows 2012 vs Windows 2016/2019 - ColdFusion 2018| View in Tracker
Reporter/Name(from Bugbase): Michael T. / ()
Failure Type: Performance Issue
Found In Build/Fixed In Build: ColdFusion 2018 Update 3-5 /
Priority/Frequency: Normal / Some users will encounter
Locale/System: English / Win All
Vote Count: 0
We are having an issue when executing either queries or stored procedures with CF2018 running on Windows 2016/2019. The same code running on Windows 2012 runs fine, however when executed on Windows 2016/2019 the execution times are 5-10x (at least) as long. The database server is MS SQL Server 2012. Enabling logging on the datasource indicates the slowdown occurs at PreparedStatement[n].execute() . On Windows 2012 it takes 15ms vs 265ms on Windows 2016/2019. We have tested this using CF2018 update 3-5 and recevied the same results, looping the same query up to 200 times. Could this possibly be related to nvarchar? See attached screenshot. I am sure the query could be optimized but we can not determine a valid reason of the slow performance due to the Window OS.