Yes. It was unexpectedly fast (under a second). From: Geoffrey Jacoby <[email protected]> Reply-To: "[email protected]" <[email protected]> Date: Wednesday, August 14, 2019 at 12:37 PM To: "[email protected]" <[email protected]> Subject: Re: Maximum sql string length
Out of curiosity, was the perf acceptable with that many parameters? (assuming of course a reasonable query against the row key or an index) Geoffrey On Wed, Aug 14, 2019 at 9:24 AM Jon Strayer <[email protected]<mailto:[email protected]>> wrote: It turns out that you can have more than 80,000 parameters in a prepared statement. From: Jon Strayer <[email protected]<mailto:[email protected]>> Reply-To: "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[email protected]>> Date: Friday, August 9, 2019 at 6:40 PM To: "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[email protected]>> Subject: Maximum sql string length 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”?
