phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jon Strayer <>
Subject Maximum sql string length
Date Fri, 09 Aug 2019 22:39:48 GMT
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”?

View raw message