Boltons: A set of BSD-licensed, pure-Python utilities

Re:Boltons: A set of BSD-licensed, pure-Python utilities by Bootvis on Wednesday October 10, 2018 @04:45AM (#18183098)

Why not insert the values in WHERE IN to a temporary helper table and join on that? It seems somewhat easier and might perform better.

[ Parent | on HN ]

Re:Boltons: A set of BSD-licensed, pure-Python utilities by orf on Wednesday October 10, 2018 @05:17AM (#18183245)

Oracle has a limit on the number of parameters in a query, not just in the `WHERE IN` clause. So you'd need to insert them into the helper table in batches of 1000.

[ Parent | on HN ]

Re:Boltons: A set of BSD-licensed, pure-Python utilities by Bootvis on Wednesday October 10, 2018 @07:25AM (#18183793)

Good point, but isn’t that done automatically by whatever tool your using?

And if the table your selecting from is big enough I would expect that this setup would be faster but it’s hard to say. It would also more easily guarantee that your results will be consistent.

[ Parent | on HN ]