cockroachdb
rand: option for using dynamic SQL instead of prepared statement
prepared statement has limit of 64K parameters. Add an option for using dynamic SQL instead of prepared statement.
What do you mean by dynamic SQL?
Also, using more than 64k parameters seems suspicious :) is it ever useful to have batches that large?
Instead of using prepared statement, issue insert into x values (1,2,3),(4,5,6)…. If the throughput continues to get better beyond 64K parameters, then this would be a viable way for bulk operation.
On Oct 24, 2017, at 4:37 PM, Jordan Lewis [email protected] wrote:
What do you mean by dynamic SQL?
Also, using more than 64k parameters seems suspicious :) is it ever useful to have batches that large?
— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/cockroachdb/loadgen/issues/90#issuecomment-339123374, or mute the thread https://github.com/notifications/unsubscribe-auth/AGBcdExWvgU-eS-n5mggOmPi3fHZ34Y4ks5svkqQgaJpZM4QFCae.