DZone Database Zone
When Using Bind Variables Is Not Enough: Dynamic IN Lists
In a previous post, I wrote about why you should (almost) always default to using bind variables. There are some exceptions, which I will cover in another follow-up post, but by default, bind variables are the right choice, both from a performance and from a security perspective.
In this article, I will show an example where regrettably, bind variables are not enough, and you can still run into significant performance issues in production. That’s when you create dynamic IN lists.
No comments:
Post a Comment