We’ve been querying one table and then creating a query against another table using a prepared statement with a very large number of parameters in a IN clause. A code review brought up a very good question, is there a limit to the size of the IN clause? Or, is there a limit to the size of the SQL use to create a prepared statement.
I assume there is some limit, but is it “well, how much memory do you have?” Or, “we have a 64k buffer”?
