| Oracle/ColdFusion/bind variables [message #53236] |
Thu, 05 September 2002 15:56  |
Mike Darevsky
Messages: 1
Registered: September 2002
|
Junior Member |
|
|
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 response will be greatly appreciated.
Thanks a lot.
Mike Darevsky
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
