-
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
-
Tell your developers to use plsql variables.....
Tarry Singh
I'm a JOLE(JavaOracleLinuxEnthusiast)
--- Everything was meant to be---
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|