Same Query Running Extremely Slower on CF 2018 vs CF 2016
I’m trying to scour the resources I have available to see if I can find the solution to this issue or at least some more pointers on where to look. So we are moving a website from one server to another. The machines are comparable and the network is the same network. The only major difference is we’re going from CF 2016 to CF 2018. On ’16, a query we have runs in about 1 second. The same query on the ’18 machine runs in about 17 to 30 seconds. I’ve been looking for ways to ensure that my ColdFusion on the new server is optimized. The old server hasn’t had any special optimizations. So I’m wondering if something changed about the way CF processes queries from 16 to 18? And does anyone have any pointers or suggestions?