Folks,

I’m trying to resolve the performance issue related to ColdFusion and dynamic list of variables in IN-list clause for various SQL statements. ColdFusion is not very good with bind variables and after several attempts developers made a decision not to use them. As a result, database is flooded with a bunch of similar SQL statements with the only difference in IN clause. The result – high latch waits/contention and poor overall performance. The solution – get back to bind variables. Do you know what be the best approach to it? Unfortunately, I don’t have a lot of experience in this area.

Your help will be greatly appreciated.

Thanks a lot.

Mike Darevsky