Oracle/ColdFusion/bind variables

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

Hi Mike,


I did work with Coldfusion and used bind variables, both in limiting conditions and IN clause, this is the best of getting good performace and also you can reduce Library cache hit ratio.